Access mysql via shell 1

[max1x]

I am trying to run queries against a mysql DB, for which I've been provided a uid & pwd, but for this I first have to login as:

mysql -u xx -p
password: xxxx
use dbName;
query

Is there a way to access the DB directly from a *nix shell and automate the login/query execution process.

 

[max1x]

I think I've found a way to access the DB directly using:

mysql -D -u xx

but I'm not sure how to grant the proper pivs to not be prompted for a password.

 

[lgarner]

You can put the username and password into the user's ~/.my.cnf, like so:

[mysql]
password=password

Set the permissions on the file to 600.