mysql_rootpass
This is an old revision of the document!
Resetting Mysql Root Password
- One-Restart Version
- Standard Practice Version]]
This is a quicker, less intrusive method with less downtime to reset mysql root password: Create the following file and then enter the command that follows
vim /var/lib/mysql/mysql.init
SET PASSWORD FOR 'root'@'localhost'=PASSWORD('mynewpassword');
Now edit: /etc/my.cnf and enter the following under the [mysqld] block
init_file=/var/lib/mysql/mysql.init
service mysqld restart
mysql -u root -pNow delete the /var/lib/mysql/mysql.init and init_file=/var/lib/mysql/mysql.init line entered in /etc/my.cnf file
DONE
mysql_rootpass.1440437504.txt.gz · Last modified: (external edit)
