On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Could it be that you are using a pre-4.1 client with a post-4.1 server? Do
> exactly what you did before except try this:
>
> UPDATE mysql.user SET
> Password=OLD_PASSWORD('my_new_password') WHERE User='root'
Did the above, put in my old password in OLD_PASSWORD and my new
password within the 'my_new_password' field (so to speak)
> You will need to FLUSH PRIVILEGES again. If this doesn't work at least we
> have eliminated another possibility.
Now I got this error message after doing mysql> FLUSH PRIVILEGES;
ERROR 1064: 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 'FLUSH PRIVILEGES' at line 2
I'm using 4.0.20 (Your MySQL connection id is 1 to server version: 4.0.20)
Thank you for your feedback, 'tis appreciated!!!
N.P
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
