How to change MySQL root user password by terminal

I know some other administrator who has forgotten the password of the root of MySQL, this can be a real inconvenience, right?

Imagine that you need to create a new database, do anything and you can't because you don't remember the password of the administrator (root) of the MySQL server, a real problem.

Here I will show you how to access the MySQL server through the terminal WITHOUT setting the root password, so that once inside you can change the root password.

Related article:

Check tables of a MySQL database and repair corrupt

The first thing will be to stop the mysql service:

service mysql stop

This stopped the service, now we are going to start it but in a different way, a way that will not ask us for a password later:

mysqld_safe --skip-grant-tables &

Ready, now let's access the MySQL terminal:

mysql -u root

They will see that it did not ask for a password, they will see that they have already entered the MySQL console or terminal and can do whatever they want, let's proceed to change the MySQL root password.

First we will enter the MySQL database as such:

use mysql;

Then, let's change the password:

update user set password=PASSWORD("ElNuevoPassword") where user='root';

Now let's refresh the privileges:

flush privileges;

And finally we go out:

quit;

Ready, we have changed the password of the MySQL root user, now we are going to stop the service and start it as it should be:

service mysql stop

service mysql start

End

This is all, they have regained control of their own MySQL server