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
--
- michael dykman
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
