Zorin OS 15 How to Reset MySQL 5.7+ root Password

Reset MySQL 5.7+ root Password Zorin OS 15

You are Welcome! The Tutorial Shows You Step-by-Step How-to Reset MySQL 5.7+ root User Password in Zorin OS 15 LTS GNU/Linux Desktop/Server.

And I’ve tried to Reset MySQL root Pass on Zorin OS 15 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…

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 Zorin OS 15 should be Successfully Solved! ;)

Tags: Zorin OS 15 Reset MySQL root Password, Zorin OS MySQL 5.7 Reset root Password