Try SET PASSWORD FOR 'root'@'localhost' = PASSWORD( 'newpwd' ); SET PASSWORD FOR 'root'@'%' = PASSWORD( 'newpwd' );
There was no username in your SET PASSWORD command.
Wes
On Jul 30, 2004, at 4:38 PM, aspsa wrote:
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]
