If you upgrade Mysql to 4.1, you have encountered the above questions, please make sure your MySQL Client is 4.1 or higher. (There is a problem under Windows, you will jump directly to the solution, because MySQL is in Windows is Client. With Server, install it together) Solution: Please use one of the following four methods one: mysql> set password for -> 'some_user' @ 'Some_host' = Old_Password ('newpwd'); instance: mysql database username For 'ABC', the password is '123456', then the statement actually implemented in the server mysql command line window is as follows: mysql> set password for -> 'ABC' @ 'localhost' = OLD_Password ('123456'); Pay attention to the English half-width semicolon after the statement ";" is indispensable. 2: mysql> update mysql.user set password = OLD_Password ('newpwd') -> where host = 'some_host' and user = 'some_user'; mysql> flush privileges; instance: mysql database user name is 'ABC', password For the '123456', the actual statement actually implemented in the server mysql command line window is as follows: mysql> update mysql.user set password = Old_Password ('123456') -> where host = 'localhost' and user = 'ABC '; mysql> flush privileges; Note the English half-width semicolon after the statement; "is indispensable. Its three: (recommended, actually and the second is the same) mysql> update mysql.user set password = old_password ('connection user password') -> where user = 'to connect the username'; mysql> flush privilege ; Example: mysql database user name is 'ABC', the password is '123456', then actually implemented in the server mysql command line window as follows: mysql> update mysql.user set password = Old_Password ('123456') -> where user = 'abc'; mysql> flush privileges; pay attention to the English half-width semicolon after the statement; "is indispensable.
