MySQL Forums :: Install & Repo :: cannot change 'root' user password

Advanced Search

cannot change 'root' user password
Posted by: Joe Mesot ()
Date: July 09, 2008 06:59AM

I just installed Mysql 5.0.51b for Mac OS X 10.3.9 using the binary installer package from the MySQL website.

MySQL installed fine and I can get it running. However, when I try to change the 'root' user password by typing :

-u root mysql UPDATE mysql.user SET Password=PASSWORD(notU) WHERE User="root";

at the mysql> prompt, I get this error message:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-u root mysql UPDATE mysql.user SET Password=PASSWORD(notU) WHERE User="root"' at line 1

how is there an error in my syntax?

Any help with this would be greatly appreciated. Please note, that I am new to both mySQL and the Unix core system of Mac OS X. I do not know terminal commands well at all and all of the reference books I have for MySQL are for older versions. Thank you so much for you time and patience.


Options: ReplyQuote

Subject Written By Posted
cannot change 'root' user password Joe Mesot 07/09/2008 06:59AM
Re: cannot change 'root' user password Alejandro Silva 07/11/2008 06:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.