mysql cannot connect to database if password is specified inline

Question

I have a problem that I think it is something easy.

I want to connect to mysql database.

If I do the following:

mysql -uroot -premoved mydatabase
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

But if I do:

mysql -uroot -p mydatabase
Enter password: removed
mysql>

It works!! Why?

Does your actual password have any unusual characters in it? These might be interpolated by the shell. — tadman
– tadman, Commented Jan 30, 2013 at 19:08

Community · Accepted Answer · 2017-05-23 11:49:02Z

1

You need single quotes around your password.

mysql -uroot '-pabc$def' mydatabase

CommunityBot

11 silver badge

answered Jan 30, 2013 at 19:02

ESG

9,4754 gold badges41 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1