Cannot access MYSQL using inline password

Question

I cant connect to mysql if I do this:

mysql -ualan -psecret

It returns:

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

But if I do:

mysql -ualan -p

And then I enter the password it works.

I NEED to use the inline password since I'm writing a script to synchronize databases with Laravel/Envoy and it doesnt allow prompt inputs.

Am I missing some configuration or something?

Assuming your password is not `secret`, are any special characters properly escaped? — Alexander O'Mara, Sep 06 '16 at 16:24
What kind of characters should be escaped? and how can I escape them? — Alan, Sep 06 '16 at 16:29
I changed the password to something cleaner and it works. Post and answer so I can vote it! — Alan, Sep 06 '16 at 16:41
Just put the password in quotes. This is not special to MySQL, it's how you use the Unix shell in general. — Barmar, Sep 06 '16 at 16:44

score 2 · Accepted Answer · answered Sep 06 '16 at 16:45

2

If your password has special characters in your shell, you would need to quote or escape them.

In bash or bash-like shells, this should work:

mysql -ualan -p'te$t'

Or

mysql -ualan -pte\$t

answered Sep 06 '16 at 16:45

Alexander O'Mara

1 Answers1