Reset MySQL Password

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_password

Output

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

Was this page helpful?