In this tutorial, I will show you how to install MySQL Community Server on macOS. Installation First, you need to go to https://dev.mysql.com/downloads/mysql/ to download the MySQL installation file for macOS: There are many different options, but you should choose the .dmg file to install… Read More

By default, if you run the command “yum install mysql-server” on CentOS 7, it will install you MariaDB server, a database system similar to MySQL. If you still want to use MySQL Server, please refer to this tutorial. I will guide you how to install… Read More

By default, MySQL does not allow us to access it from other machines, accessible only from the machine itself. Therefore, if we want to access MySQL from another machine, we must make changes in the configuration of MySQL. What the changes are, in this tutorial,… Read More

To change the password of any MySQL user, please login to MySQL with the user have right permission to change the data in the database. Here, I will use the root account:

Enter and then enter the password. By default, all user information is… Read More

When working on a project that uses MySQL, on your computer you usually use the root user with all the rights to manipulate the database. This is nothing to say, but imagine if you were working in a production environment, where any database-related errors will… Read More

In this tutorial, I will show you the way to reset MySQL root password in macOS. Note: I work with MySQL 5.7.x for this tutorial, First of all, we need stop MySQL server using MySQL Start/Stop Configuration as below: Then, open Terminal and start MySQL… Read More