In Linux, mysql modifies the user name and password

Source: Internet
Author: User
Next I will introduce some methods for changing the password of mysql. The simplest is to modify the password of mysql directly in phpmyadmin or command mode, the other is to change the password in command mode.

Next I will introduce some methods for changing the password of mysql. The simplest is to modify the password of mysql directly in phpmyadmin or command mode, the other is to change the password in command mode.

If you forget the MySQL root Password, You can reset it using the following methods:

1. KILL the MySQL process in the system;

The Code is as follows:
Killall-TERM mysqld

2. Run the following command to start MySQL without checking its permissions;

The Code is as follows:
Safe_mysqld-skip-grant-tables &

3. Use the empty password to log on to MySQL as the root user;

The Code is as follows:
Mysql-u root

4. Modify the password of the root user;

The Code is as follows:
Mysql> update mysql. user set password = PASSWORD ('new password') where User = 'root ';
Mysql> flush privileges;
Mysql> quit

Restart MySQL to log on with the new password.


Knowing the mysql password is simple modification.

1. Modify records directly in the database

The Code is as follows:

Mysql> use mysql

Mysql> update user set password = password ("new_password") where user = "user_name ";

Mysql> flush privileges;

In fact, this method is to update a database record. Unlike normal update statements, the password is encrypted and generated using the password () function. Another difference is that the permission table needs to be refreshed.

2. Run set password in the database

The Code is as follows:

Mysql> set password for user_name = password ("new_password ");

Mysql> flush privileges;

In the same method, you must refresh the permission table.

3. Run mysqladmin directly in the shell Environment

The Code is as follows:

> Mysqladmin-u user_name-p password "new_password"

> Mysqladmin flush-privileges


4.

The Code is as follows:

Grant all privileges on db. table to user_name @ localhost identified by "set password ";

Do not use flush privileges to refresh the user name and password

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.