ERROR 1045: Access denied for user:

Michael S. Dunsavage mikesd at frontiernet.net
Tue Mar 30 18:48:01 UTC 2004


I get the following error when I do

mysql -u mikesd -p

ERROR 1045: Access denied for user: 'mikesd at localhost' (Using password: YES)


the user mikesd exists.

I did

mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost'
     ->     IDENTIFIED BY 'pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'%'
     ->     IDENTIFIED BY 'pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';


What else?

-- 
Michael S. Dunsavage





More information about the redhat-list mailing list