MySQL Modify user password

Directory

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

The
1. mysqladmin command (headings) is formatted as follows (where user is the username, password is the new password): mysqladmin-u user-p password Password The command will prompt for the original password, enter the correct can be modified.
   For example, to set the root user's password to 123456, mysqladmin-u root-p password 123456
The
2. Update user statement (headings) must first log in to MySQL with the root account and then execute: Update user SET Password=password (' 123456 ') WHERE user= ' root ';
   FLUSH privileges;
The
3. set PASSWORD statement (headings) is also required to log in to MySQL with the root command first and then execute: Set PASSWORD for Root=password (' 123456 ');
4. The root password is missing (headings) 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:
   If the original service configuration is normal, select "Startup variable" in the list on the left, and select "Security" in the appropriate right-hand tab, tick "Disable Grant table" and then "Apply Changes".
   
   and go back to "server control" on the left, and the corresponding "Start/Stop Services" tab on the right, click Start Service. At this point, the connection to MySQL has no user name and password, you can change the root password.