Trying to write script that tests mysql login

drigby · 04-09-2012, 10:15 AM

Hi,

I'm familiar with PHP, but bash is pretty new to me.

I'm writing a bash script that logs into mysql. I need the script to test whether it's using the proper mysql user/pass, so that it can switch to another if necessary. The problem is everything I've tried throws an error, and ends the script.

What I've been doing so far looks like this (though I've tried many variations):

Code:

mysql -h localhost -u Username -pPassword <<EOF; exit; EOF
if [ "$?" != "0" ]; then
  # Code that tests alternate credentials
fi

I've tried using -f to keep the errors from stopping the script, but I think that "force" does not apply to the mysql command itself. I think "force" only applies to the commands executed in mysql.

I don't see any other options in the man page that seem to apply to what I'm doing. Could have misunderstood something though.

Does anyone have some code that would work in this situation?

Thanks in advance!

JSkywalker · 04-09-2012, 10:25 AM

If you are on linux (i think it can be done on Windows too, but i did not test that) you can create a file called '.my.cnf' in your home-directory

Quote:

[client]
user=Username
password=Password

After is you can start mysql without the username/password. The '-h localhost' is not needed when you try to access mysql on your local system.

drigby · 04-09-2012, 10:34 AM

I want to have root privileges to mysql, and in this case I won't know if any password has been set on mysql. I'm guessing that if I use your method, and the root password has previously been set, I'm not going to get into mysql with full privileges?

I could be wrong though.

JSkywalker · 04-09-2012, 10:43 AM

no, if you want to have access, you should know the 'proper' password