MySQL ERROR 1045 in bash script - access denied

Question

I'm trying to run a MySQL command from a bash script:

mysql --user=[USER] --password=[PASSWORD] --database=[DATABASE] --execute="DELETE FROM table WHERE created_at < NOW() - INTERVAL 7 DAY"

Both in the bash script and terminal, I get the same error:

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

I've tested running mysql -u [USER] -p and that will connect so I know my credentials are correct.

What am I missing? I've seen a few things online suggesting the port may be wrong, but it's all set running on localhost, which is correct

acutally, i've just figured it out: there's a $ in my password which bash is trying to interpret as a variable. Is there a way to escape the $ rather than changing my password? — TH1981
– TH1981, Commented Aug 14, 2014 at 2:09

TH1981 · Accepted Answer · 2014-08-14 02:21:25Z

3

figured it out. The problem wasn't the permissions, but the password itself. I needed to escape a $ in my password, so the code changed to the following (using the password pass$word):

mysql --user=[USER] --password=pass\$word --database=[DATABASE] --execute="DELETE FROM table WHERE created_at < NOW() - INTERVAL 7 DAY"

works like a charm now.

answered Aug 14, 2014 at 2:21

TH1981

3,2137 gold badges49 silver badges78 bronze badges

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

Comments

nice · Accepted Answer · 2014-08-14 02:13:03Z

1

1.maybe you should check into your mysql table mysql.user if USER and localhost in this table, if no add your USER

2.check your USER privileges if USER has right to get into this databases.

answered Aug 14, 2014 at 2:13

nice

113 bronze badges

Collectives™ on Stack Overflow

MySQL ERROR 1045 in bash script - access denied

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related