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
 
  • 1 Users Found This Useful
這篇文章有幫助嗎?

相關文章

How do I SSH into my VPS? (OS X/Terminal)

If you are on a Mac, SSH-ing into your VPS is very simple. Simply launch "Terminal" by going to...

Setup Nginx PHP FPM Percona Mysql

Setup Nginx + php-fpm + Percona Mysql LEMP stack is a group of open source software to get...

Install PHP/PHP-FPM 5.4 Centos 7

Install PHP/PHP-FPM 5.4 on Centos 7 PHP is a server-side scripting language designed for web...

How to Optimize/Repair a Table (MySQL)

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

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...