Help Please: Password Setup for MySQL 5.0.45
Posted by:
swaruprajsekar
(---.sify.net)
Date: January 25, 2008 09:08AM
Hello,
I am getting the following error message while setting up Password for MySQL 5.0.45: (my first time)
ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL version for the right syntax to use near 'WHERE user='root'; at line 3
The syntax i used is:
- Enter password: (enter)
(Welcome to the MySQL monitor, etc.......)
- use mysql
- UPDATE user
- SET Password=PASSWORD<'mypassword'>
- WHERE user='root';
Please advise.
Thanks in advance for your help!
>Swarup