Five easy steps to reset MySQL root password.
- Stop the MySQL server.
- Start the MySQL server with the --skip-grant-tables option. (it will not prompt for password)
- Connect to MySQL server as the root user.
- Setup new MySQL root password.
- Exit and restart the MySQL server.
### Shell Commands ###
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
### SQL Commands ###
use mysql;
UPDATE user SET password=PASSWORD("new-password") WHERE user='root';
flush privileges;
exit
### Shell Commands ###
/etc/init.d/mysql stop
/etc/init.d/mysql start
mysql -u root -pnew-password
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}