I have a shell script which calls the mysql command with one parameter from external file, it looks like this (also I saw this example in other resources):
mysql --user=root --password=`cat /root/.mysql`
Bit it not working:
Failed to connect to MySQL server: Access denied for user 'root'@'localhost' (using password: YES).
I tried different quotes without success. How to pass it?
UPDATE 1: Found that I can pass password without space symbol. The problem in this, my root pass contains spaces.
Finally this line working:
mysql --user=root --password="$(cat /root/.mysql)"
or:
mysql --user=root --password="$(< /root/.mysql)"
Root password must be without quotes: bla bla bla
If your password not contains spaces you can use:
mysql --user=root --password=`cat /root/.mysql`