WampServer

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

Check Setup Password on my personal websites

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides