How to modify the MySQL user (root) password _linux shell under Linux

Below to share under Linux How to modify the MySQL user (root) password, divided into two cases: the first when the original MySQL root password, the second situation to forget the original MySQL root password.

The modified user is in the column root.

A, with the original MySQL root password;

Method One:

Outside the MySQL system, use the Mysqladmin

Copy Code code as follows:

# mysqladmin-u root-p Password "test123"

Enter Password: "Enter the original password"

Method Two:

By logging in to the MySQL system,

# mysql-uroot-p

Enter Password: "Enter the original password"

mysql>use MySQL;

mysql> Update user Set Password=password ("test") where user= ' root ';

mysql> flush Privileges;

Mysql> exit;   

Second, forget the original MySQL root password;

First, you have to have the operating system root permissions. If you don't have root access to the system, consider the root system and then follow the steps below.

Similar to the Safe Mode login system, it is suggested that Pkill MySQL, but I do not recommend Kazakhstan. Because when you execute this command, it can lead to a situation like this:

Copy Code code as follows:

/ETC/INIT.D/MYSQLD status
Mysqld dead but Subsys locked

So even if you are in Safe mode to start MySQL may not be useful, so generally it is so/etc/init.d/mysqld stop, if you unfortunately first used Pkill, then start to stop again.

Copy Code code as follows:

# Mysqld_safe--skip-grant-tables &

To run in the background, no longer running in the background, then open a terminal slightly.

Copy Code code as follows:

# MySQL
mysql> use MySQL;
mysql> UPDATE user SET Password=password ("test123") WHERE user= ' root ';
mysql> flush Privileges;
Mysql> exit;

# #本来mysql是不分大小写的, but this is the specific value of the MySQL database modified in MySQL, to be noted.

The above content is under Linux How to modify the MySQL user (root) password of the entire content, I hope you like.