mysqlmysql-connect

Access denied for user 'root'@'localhost' when password print on bash

I am using mysql 5.6 I want to connect mysql from bash.

mysql -u root -pAdmin@1234

i am getting following error-

Warning: Using a password on the command line interface can be insecure.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

But if i used -

mysql -u root -p

and provide password manually then it works. Can any one help me out this issue.

Solution

  • I think your password is not exactly "Admin@123". If there are any special characters, use the escape character " \ " in the command line and try it.