If root password or mysql root password were changed, follow procedure below to reset root password in mysql and create .rocks.my.cnf file.
Stop Rocks foundation-mysql
- /etc/init.d/foundation-mysql stop
Start mysql with options below
- /etc/init.d/foundation-mysql start --skip-grant-tables
Connect to Mysql using Rocks, not OS MySql
- /opt/rocks/bin/mysql -u root
- Select the database
- mysql> use mysql;
- Update the password
- mysql> update user set password=PASSWORD("newrootpassword") where User='root';
- Flush privileges
- mysql> flush privileges;
- Exit
- mysql> quit
