MX Linux 19 Reset MySQL/MariaDB Root Password

Reset MySQL/MariaDB 5.7+ root Password MX Linux 19

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

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

1. First, Try to Recover Default Password
   Look into the Default MySQL Config file:

   sudo cat /etc/mysql/debian.cnf

   Then Try to Login with the Given Pass.

2. Stop MySQL Server.

   sudo service mysql stop

   Or in case:

   sudo service mariadb stop

3. Make the Needed Directory.

   sudo mkdir /var/run/mysqld

   And Set mysql as User

   sudo chown mysql: /var/run/mysqld

4. Start mysqld_safe.

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

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

   mysql -uroot mysql

6. 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.

7. 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

8. 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 MX Linux 19 should be Successfully Solved! ;)