User Tools

Site Tools


mysql_rootpass

Warning: Undefined variable $html in /usr/share/nginx/html/lib/plugins/tabinclude/helper.php on line 240

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 -p  
Now 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.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki