Xubuntu 18.04 Reset MySQL/MariaDB Root Password

Reset MySQL/MariaDB 5.7+ root Password Xubuntu 18.04

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

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

1. Stop MySQL Server.

   sudo service mysql 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

7. Restart MySQL Server.

   sudo service mysql start

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