Databases

How to Deploy and Manage MongoDB with Docker

February 25, 2020

This tutorial shows you how to use Docker and an official MongoDB container image to deploy your databases. Additionally, it covers basic commands that allow you to interact with the MongoDB client effectively.

Read more

How to Change MySQL Server Time Zone

February 19, 2020

Your server's MySQL time zone and your own might be out of sync. Read this article to learn 2 ways of editing your MySQL time zone and make it easier for you to read server logs and data.

Read more

How to Install MySQL on CentOS 8

February 17, 2020

MySQL, the most widely used relational database management system can be installed on CentOS 8 from the default AppStream repository or from the official MySQL developer's repository. This article details both options and instructs how to secure your databases.

Read more

MySQL Docker Container Tutorial: How to Set Up & Configure

February 10, 2020

Deploying MySQL in a container is a fast and efficient solution for small and medium-size applications. Instead of setting up a separate MySQL server, you can deploy a MySQL database container instead. These containers are lightweight and fast to spin up since they share the kernel and libraries of the host while packaging the deployed application.

Read more

How to Create MySQL Database in Workbench

January 29, 2020

Workbench is a cross-platform, open-source, visual tool for database management. It provides a user-friendly GUI in which you can create and maintain databases. Learn how to create a MySQL database and table in Workbench, as well as how to add data to a table.

Read more

How to Find and Terminate / Kill MySQL Process

January 23, 2020

Killing a MySQL process can help you boost the performance of your server. By running a few commands, you can identify which processes might be holding back your system and then kill individual processes or all of them.

Read more

MySQL Performance Tuning and Optimization Tips

January 15, 2020

The performance of MySQL databases is an essential factor in the optimal operation of your server. Make sure you are avoiding the common pitfalls concerning MySQL queries and system setup.

Read more

How to Fix MySQL 'Command Not Found' (Linux, Windows, mac OS)

December 11, 2019

The 'Command Not Found' error is a general error not only found in MYSQL. By learning how to deal with it, you will learn how to fix it in other situations as well. The three major operating systems are covered in this comprehensive tutorial.

Read more

How To Remove or Delete a MySQL User Account

December 1, 2019

This article covers the basics of using the DROP USER statement used to delete MySQL user account. Follow the step-by-step instructions and remove one or multiple accounts in a matter of seconds.

Read more

How to Install MongoDB on Ubuntu 18.04

November 26, 2019

MongoDB is a database program that provides high performance, high availability, and automatic scaling to your databases. Use this tutorial to learn how to install MongoDB using two different methods. The article also shows you how to implement basic security features to get you started.

Read more