Reset MySQL Root Password On Linux
DZone's Guide to
Reset MySQL Root Password On Linux
Join the DZone community and get the full member experience.
Join For FreeJava-based (JDBC) data connectivity to SaaS, NoSQL, and Big Data. Download Now.
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
Connect any Java based application to your SaaS data. Over 100+ Java-based data source connectors.
Like This Article? Read More From DZone
Topics:
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}