MySQL Forums
Forum List  »  Install & Repo

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

Written By
cannot change 'root' user password
July 09, 2008 06:59AM

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.