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
這篇文章有幫助嗎?

相關文章

Install Mysql Database Centos 7

Install Mysql Database on Centos 7 MySQL is a popular choice of database for use in web...

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 ionCube Loaders for Centos

Installing ionCube Loaders for Centos 6 PHP 5.4 This module is basically PHP extension that...

How to block a bot by User Agent Sting

How to block a bot by User Agent Sting Do you have those bandwidth hogging bots as much as...

How to block Bittorent traffic with IPTables

How to Block Bittorrent Traffic with IPtables IPTABLES is a user-space application program...