MYSQL Access Denied


#1

Not able to login in MySQL. I am getting the following error :-
’ [abhishekga@server-1 ~]$mysql -u abhishekga -p
Enter password:
ERROR 1045 (28000): Access denied for user ‘abhishekga’@‘localhost’ (using password:
YES)

Please resolve it asap.


#2

What happens when you type the command ‘mysql’ without any options?


#3

Hi All,

I am not able to login in Mysql. kindly do needful .

Thnaks and Regards,
Sumit Pandey


#4

this is the error i get by just typing mysql

**[abhishekga@server-1 ~]$mysql **
ERROR 1049 (42000): Unknown database 'db_abhishekga’


#5

Please let us know the error message. thanks @ramjee


#6

Please try again now. It should work.


#7

Dear Laks,

I am normally login like :- mysql -u ramjee -p

After that it showing below error .

Error 1045 (28000) : Access denied for user ‘ramjee’@’ localhost’ (using password : Yes)

Kindly do needful.

Thanks and Regards,
Sumit Pandey
9810858475


#8

What happens when you simply type ‘mysql’ - You won’t need to pass user or password on webminal for mysql. It should work automagically :slight_smile:


#9

Dear Laks,

I entered " $ mysql " only . Then it showing below error.

Error 1049 (42000) : Unknown database ‘db_name’ .

Kindly look into it.

Regards,
Sumit Pandey
9810858475


#10

Okay, can you again the same command ‘mysql’ - I restarted mysql service now.


#11

Thanks Sir,

It’s working now.:slightly_smiling_face:

Regards,
Sumit Pandey
9810858475