Xubuntu 20.04 Reset MySQL/MariaDB Root Password

Reset MySQL/MariaDB 5.7+ root Password Xubuntu 20.04

Hi! The Tutorial shows you Step-by-Step How to Reset MySQL/MariaDB 5.7+ root User Password in Xubuntu 20.04 Focal LTS GNU/Linux Desktop/Server.

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

1. Stop MySQL Server.

   Copy

   sudo service mysql stop

   Or in case:
   Copy

   sudo service mariadb stop

2. Make the Needed Directory.

   Copy

   sudo mkdir /var/run/mysqld

   And Set mysql as User

   Copy

   sudo chown mysql: /var/run/mysqld

3. Start mysqld_safe.

   Copy

   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:

   Copy

   mysql -uroot mysql

5. Setting New Pass.

   Copy

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

   Copy

   FLUSH PRIVILEGES;

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

6. Kill mysqld Process

   Copy

   sudo pkill mysqld

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

   ps ax | grep mysqld

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

   sudo kill -9 166394

7. Restart MySQL/MariaDB Server.

   Copy

   sudo service mysql start

   Or:
   Copy

   sudo service mariadb start

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