Hi,
If you facing this issue please follow these steps to change your MySQL root password :
1. Firstly Stop MySQL service, use this command and execute it multiple times untill no mysqld process is running :
service mysqld stop
2. Start MySQL with option:
/usr/local/apps/mysql56/mysqld --skip-grant-tables
3. Login to MySQL as:
mysql -u root
4. Change database to mysql as:
use mysql;
5. Update root user password as:
update user set password=PASSWORD("NEWPASSWORD ") where user='root';
note: NEWPASSWORD should be replaced with desired password, everything else stays the same...
5.5 Flush the privileges using the following command :
flush privileges;
6. Exit from mysql, using the command:
exit;
7. Stop all MySQL service as (execute it multiple times until no process is present):
killall mysqld
8. Start MySQL service normally as:
service mysqld restart
9. Check whether new password is working fine by loging in as:
mysql -u root -p
note: After this MySQL will prompt you for password. Please enter the NEWPASSWORD set by you above.
10. Update /var/webuzo/my.conf with the new working password.
|