[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

ERROR 1045: Access denied for user:



I get the following error when I do

mysql -u mikesd -p

ERROR 1045: Access denied for user: 'mikesd 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




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]