MySQL access denied from bash when executing MySQL commands

Question

When I log in to mysql from a bash script such as this:

mysql --user="$USERNAME" --password="$PASSWORD" --database="$DATABASE" << EOF
# No command here
EOF;

My user is logged into the database and it works fine. But when my bash script does something as simple as

mysql --user="$USERNAME" --password="$PASSWORD" --database="$DATABASE" << EOF
show tables;
show columns from some_table;
...
# Now there are commands
EOF;

Mysql gives me this error: Access denied for user 'user'@'localhost' to database 'database' What would cause this?

To clarify, I'm perfectly able to just call mysql -uUser -pPass database from the command line, log in, then call show tables;. It's only when run from a bash script, and when that bash script includes a mysql command does my access get denied.

Furthermore is there a simple-to-use library for python/c++ that handles mysql interaction and doesn't involve having to sign up for something in order to obtain the library?

Ray · Accepted Answer · 2014-03-07 22:19:46Z

1

I always use the -e flag for passing commands in a script:

  mysql --user="$USERNAME" --password="$PASSWORD" --database="$DATABASE"  -e "show tables;"

answered Mar 7, 2014 at 22:19

Ray

41.6k22 gold badges110 silver badges143 bronze badges

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

12 Comments

kjh Over a year ago

I'm actually calling more than one command, sorry for not specifying, for that reason I'm using the << operator.

Ray Over a year ago

@kjh you can specify as many command you want separated by a semicolon

kjh Over a year ago

Ah ok. I'll go ahead and give this a try. does it ignore newlines?

Ray Over a year ago

I'd assue so as long as the starting quote is on the same line as the -e

Barmar Over a year ago

It should still work as the question wrote it. mysql will read from stdin if there's no -e option, and I have many scripts that pipe to mysql.

|

Collectives™ on Stack Overflow

MySQL access denied from bash when executing MySQL commands

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related