GNU/Linux CentOS 7 Reset MySQL/MariaDB Root Password

Reset MySQL/MariaDB 5.7+ root Password CentOS 7

Hi! The Tutorial shows you Step-by-Step How to Reset MySQL/MariaDB 5.7+ root User Password in CentOS 7.x GNU/Linux Desktop/Server.

And I’ve tried to Reset MySQL root Pass on CentOS 7 in many Ways but this was the Only one Working Solution!

1. Stop MySQL Server.

   sudo service mysql stop

   Or in case:

   sudo service mariadb stop

2. Make the Needed Directory.

   sudo mkdir /var/run/mysqld

   And Set mysql as User

   sudo chown mysql: /var/run/mysqld

3. Start mysqld_safe.

   sudo mysqld_safe --skip-grant-tables --skip-networking &

4. Login into MySQL without Pass
   Open a New Window or Demonize the process with Ctrl+c:

   mysql -uroot mysql

5. Setting New Pass.

   UPDATE mysql.user SET authentication_string=PASSWORD('YOUR-NEW-PASS'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';

   FLUSH PRIVILEGES;

   Change “YOUR-NEW-PASS” in the Above…
   And then “Ctrl+c” to Quit MySQL.

6. Kill mysqld Process

   sudo pkill mysqld

   But you may need to find out the mysqld process with:

   ps ax | grep mysqld

   And then use the process ID to kill it as Eg.:

   sudo kill -9 166394

7. Restart MySQL/MariaDB Server.

   sudo service mysql start

   Or:

   sudo service mariadb start

And with this your Issue of Resetting MySQL 5.7 Pass on CentOS 7 should be Successfully Solved! ;)