Bugs in MySQL and how to fix them

1.Change Password hint ERROR 1054 (42S22): Unknown column ' Password ' in ' Field List '

Cause of Error:There is no password this field under the MySQL database, and the password field has been changed to authentication_string. Workaround:

• 　　　　　　　Find the My.ini configuration file from the MySQL decompression path, remove the skip-grant-tables comment from it, and if you don't add it to yourself (usually),

• Execute the following command at the MySQL command line (password changes to your own password):

  mysql>  Update mysql.user set Authentication_string=password (' PASSWORD ') where user= ' root ';

  The result is this:

  Query OK, 1 row affected, 1 warning (0.15 sec) Rows matched:1  changed:1  warnings:1

  　　

• After running back to the MySQL decompression path, the My.ini configuration file in the Skip-grant-tables again commented out (add a # in front of the line)
• Finally, restart MySQL.
• Ok

Bugs in MySQL and how to fix them