Process for changing MySQL root password on CentOS Web Panel from command line

Change MySQL root password on CentOS Web Panel.md

Process for changing MySQL root password on CentOS Web Panel from command line

Run CWP's script to reset password

$ sudo sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset

** Make note of the new password provided by the script

Log in as root with old password

$ sudo mysql -u root -p

Run the following queries, replacing with new password provided by the script

> GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY '<password>';
> FLUSH PRIVILEGES;
> exit

Test that the new password works:

$ sudo mysql -u root -p
> exit

Restart CWP for good measure

$ systemctl restart cwpsrv