GNU/Linux Reset MySQL/MariaDB 5.7+ root Password
Hi! The Tutorial shows you Step-by-Step How to Reset MySQL/MariaDB 5.7+ root User Password in GNU/Linux Desktop/Server.
And I’ve tried to Reset MySQL root Pass on Linux in many Ways but this was the Only one Working Solution!
Stop MySQL Server.
sudo service mysql stop
Or in case:sudo service mariadb stop
Make the Needed Directory.
sudo mkdir /var/run/mysqld
And Set mysql as User
sudo chown mysql: /var/run/mysqld
Start mysqld_safe.
sudo mysqld_safe --skip-grant-tables --skip-networking &
Login into MySQL without Pass
Open a New Window or Demonize the process with Ctrl+c:mysql -uroot mysql
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.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
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 Linux should be Successfully Solved! ;)