Matt,
Is there a space between PASSWORD and the opening parenthesis? There
shouldn't be, if there is. Otherwise, your statement worked without errors
for me on MySQL Version 4.0.16.max-nt.
Make sure that you are logged in as root.
C : \ >select user();
Sometimes MySQL is cryptic about its error messages for security reasons.
dave
"Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@xxxxxxxxxxxx>
10/19/2004 08:24 AM
To:
php-db@xxxxxxxxxxxxx
cc:
Subject:
RE: setting root password
After going to the command prompt I have done exactly this:
c:\>cd C:\mysql\bin
c:\mysql\bin>mysql -uroot -p
mysql>SET PASSWORD FOR root@localhost=PASSWORD('mypassword');
I get the following familiar message:
You have an error on your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_____
From: dpgirago@xxxxxxxxxxxxxx [mailto:dpgirago@xxxxxxxxxxxxxx]
Sent: Monday, October 18, 2004 1:35 PM
To: php-db@xxxxxxxxxxxxx; Perry, Matthew (Fire Marshal's Office)
Subject: Re: setting root password
If you haven't yet deleted the localhost root account, you can log onto
the
mysql client with:
mysql> mysql -uroot -p
then press enter again when it prompts you for a password.
You should now be able to manage all your account info.
dave
"Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@xxxxxxxxxxxx>
10/18/2004 01:28 PM
To:
php-db@xxxxxxxxxxxxx
cc:
Subject:
setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others". What could I be doing incorrectly?
-Matt
