Linux forgot Mysql password processing method _mysql

Source: Internet
Author: User
Tags flush safe mode root access pkill

Linux forgot MySQL password processing method:

#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> Update user Set Password=password (' NewPassword ') where user= ' root ';
mysql> flush Privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql>

The modified user is in the column root.

First, the original myql of the root of the password;

Method One:
Outside the MySQL system, use the Mysqladmin
# 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;

Method Three:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';


mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql> Grant all on *.* to root@ '% ' identified by ' password ';

Method Four:

Use the username and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql>
Second, forget the original myql of the 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:
/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.
# Mysqld_safe--skip-grant-tables &
To run in the background, no longer running in the background, then open a terminal slightly.
# 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.