FLUSH PRIVILEGES is not necessary after SET PASSWORD or GRANT. You only
need to FLUSH PRIVILEGES when you edit the mysql tables directly (INSERT,
UPDATE, DELETE).
Michael
Michael Dykman wrote:
after you ran your command, did you:
mysql> flush privileges;
?
Per the MySQL documentation I used the following commands to establish login
both at the local host and remotely.
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
When I attempt the following locally from the Command Prompt (with Win2K,
SP4 administrator privileges),
mysql -u root -p
, I am prompted for the password. Yet, when I enter the password set above,
I receive the following error message.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Argh... your help is appreciated.
Respectfully,
ASP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]