Reset your MySQL Admin Password

How to reset your MySQL Admin Password

You have installed MySQL and now you are having a hard time remembering the password, what should we do? Lets reset the MySQL root password.

You will need to login as the root user

First: Need to stop MySQL

/etc/init.d/mysql stop

or

killall mysql

Second: Create a msyql password sql script

vim /root/mysql.reset.sql

Append the following code:

UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;

Save and close the file

Third: Set the new mysql root password

mysqld_safe --init-file=/root/mysql.reset.sql &

Output should be:

nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[20970]: started

And now you are done resetting the mysql root password

Now simply stop and restart mysql

killall mysqld
/etc/init.d/mysql start
 
  • 3 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Articles connexes

How to Optimize/Repair a Table (MySQL)

How to Optimize and Repair your MySQL Tables Does your database feel like it has slowed down?...

How To Add Date and Time To Bash History

As Linux users and engineers, we often have to look back in our bash history to figure out...

APF Firewall -Advanced Policy Firewall - Basics

APF Firewall -Advanced Policy Firewall - Basics Advanced Policy Firewall, or APF, is a...

Setup a SSH Tunnel for Secure Browsing

Setup a SSH Tunnel to Secure your Browsing on a Public Network Have you been sitting at your...

Install mod extact forward - Show Real IP behind Proxy

How to Show the Real IP when Behind a Proxy mod_extract_forwarded is designed to transparently...