

Make sure to replace new_password with your new password of choice. SET PASSWORD FOR = PASSWORD(' new_password').ALTER USER IDENTIFIED BY ' new_password' įor MySQL 5.7.5 and older as well as MariaDB 10.1.20 and older, use:.Now we can actually change the root password.įor MySQL 5.7.6 and newer as well as MariaDB 10.1.20 and newer, use the following command. Let’s tell the database server to reload the grant tables by issuing the FLUSH PRIVILEGES command. However, this command won’t work right now because the grant tables aren’t loaded. One simple way to change the root password for modern versions of MySQL is using the ALTER USER command. Now that you have root access, you can change the root password. Type '\c' to clear the current input statement. MariaDB prompt Type 'help ' or '\h' for help.

You’ll immediately see a database shell prompt instead. Now you can connect to the database as the root user, which should not ask for a password. The ampersand at the end of this command will make this process run in the background so you can continue to use your terminal.

Step 3 - Restarting the Database Server Without Permission Checking To change the root password, you have to shut down the database server beforehand.Īfter the database server is stopped, you’ll access it manually to reset the root password. Next, you need to stop the database so you can access it manually. Make note of which database and which version you’re running, as you’ll use them later.

MariaDB outputmysql Ver 15.1 Distrib 5.5.52- MariaDB, for Linux (x86_64) using readline 5.1
