Example of a Linux system that modifies the MySQL root password

Login to the MySQL system:

code is as follows	copy code
#  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;

Outside the MySQL system, use mysqladmin:

The code is as follows	Copy Code
# mysqladmin-u root-p password ' Test123″

Enter Password: "Enter the original password"

forget the password of the original MYQL root:

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 Safe Mode login system, it is suggested that pkill MySQL, but I don't recommend it. Because when you execute this command, it can lead to a situation like this:

The code is as follows	Copy Code
/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 is this /etc/init.d/mysqld Stop, if you are unlucky to use the Pkill first, then start the stop again.

The code is as follows	Copy Code
# Mysqld_safe–skip-grant-tables &

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

The code is as follows	Copy Code
# 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.