How to reset a mysql password from the command line
I just got WordPress installed and completely forgot to change the random password it started me off with to something I might have a chance of remembering. So to change it, I opened a terminal and changed the password field for the account I just created in mysql. Here’s how:
First you’ll need to get your password encrypted using openssl.
$ # openssl passwd -1 my_super_secret_password
$1$AIO1MlAJ$nTI.HbEKpuYRbtCpn.5Vu/
Copy this hash so you can paste it into your sql statement later. Now connect to mysql.
$ mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 976
Server version: 9.7.6evil Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>
If you know the database name you can just connect to it, if your forgot, which I did, just list them all.
mysql> show databases;
Connect to your wordpress database.
mysql> connect my_wordpress_database_name;
And change the password.
mysql> update wp_users
-> set user_pass=’$1$AIO1MlAJ$nTI.HbEKpuYRbtCpn.5Vu/’
-> where user_login=’admin’;
And that’s it; all done. Now you can get back to editing…
