Description
This guide will show you how to Reset MySQL password via Command Line.
If you have difficulty logging into phpMyAdmin and MySQL, you can reset the MySQL password by executing the following command.
Command
webuzo --reset_mysql_passwordOutput
Stopping MySQL ...
Starting MySQL in safe mode ...
Connecting to MySQL
- Connection Attempt 1 SUCCESSFUL
Setting the new password ...
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'XXXXXXXXXXXXXXXXXXX'
- Return : 1
Saving the new password for Webuzo ...
Restarting MySQL normally ...
Password reset successful ! Exiting the script.
Note : A new random password will be set for MySQL. You can find the password in /var/webuzo/my.conf