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 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

İlgili diğer dökümanlar

How do I reset my root password?

To reset your VPS root password, enter the VPS management panel at https://vps.hostodo.com:4083...

Expand your bash history to 2500

Expand your .bash_history to 2500 I do alot of testing and alot of work on Centos servers. I...

Install Remi and EPEL yum repo Centos 7

Install Yum EPEL and Remi repositories on Centos 7 Adding additional useful repo's on Centos 6...

Install Redis on Centos 7 How To

How To install Redis on Centos 7 Redis is an open source, BSD licensed, advanced key-value...

CentOS One Liner Commands

Centos Oneliners kill all pts for x in $(ps aux | grep pts| awk '{print $2}'); do kill...