Modify MySQL user password

Modify MySQL user password

Directory

1. Mysqladmin command
2. UPDATE User Statement
3. SET PASSWORD Statement
4. Root password loss (to be verified)

1. mysqladmin Command (headings)

   The format is as follows (where user is the username and password is the new password):

   mysqladmin-u user-p Password Password

   After this command, you will be prompted to enter your original password, and you can modify it after entering it correctly.
   For example, to set the root user's password to 123456, the

   Mysqladmin-u root-p Password 123456

2. UPDATE User statement (headings record)

   This must be done first by logging in to MySQL with the root account and then executing:

   UPDATE user SET Password=password (' 123456 ') WHERE user= ' root ';
   FLUSH privileges;

3. SET PASSWORD statement (headings record)

   This approach also requires that you log in to MySQL with the root command and then execute:

   SET PASSWORD for Root=password (' 123456 ');

4. Root password is missing (headings record)

   Using MySQL's own tool "MySQL GUI tools", I have been using the 5.0 version. Run a program MySQLSystemTrayMonitor.exe in the installation directory and the icon will appear in the system tray when you are finished running. If the MySQL service is not already installed, it will not appear, but first configure and install the service via Action>manage MySQL Instances. If the service is already installed, the right mouse button will appear after the "Configure Instance" menu. After clicking, the following MySQL administrator window appears:

This article is from "_xiaohan" blog, please make sure to keep this source http://yingmeng.blog.51cto.com/5365464/1558599

Modify MySQL user password