How to pass password from file to mysql command?

Question

I have a shell script that calls the mysql command with one parameter from an external file, it looks like this (and I saw this example in other resources):

mysql --user=root --password=`cat /root/.mysql`

Bit does not work:

Failed to connect to MySQL server: access denied for user 'root' @ 'localhost' (using password: YES).

I tried different quotes without success. How to convey this?

UPDATE 1: Found that I can pass a password without a space character. The problem is this, my root pass contains spaces.

Answer 1

Finally, this line works:

 mysql --user=root --password="$(cat /root/.mysql)"

or

mysql --user=root --password="$(< /root/.mysql)"

The root password must be without quotes: bla bla bla

, :

mysql --user=root --password=`cat /root/.mysql`

Answer 2

mysql cnf:

install -m 700 -d /srv/secrets/
install -m 600 /dev/null /srv/secrets/[e-mail]
editor /srv/secrets/[e-mail]

client.password ini

[client]
password="password"

mysql:

mysql \
    --defaults-extra-file=/srv/secrets/[e-mail] \
    --user=root \
    --host=localhost \
    --no-auto-rehash

Answer 3

mysql_config_editor .

$ mysql_config_editor set \
    --login-path=name_of_connection \
    --host=server.example.com \
    --user=login_as_user \
    --password

.mylogin.cnf .

mysql --login-path=name_of_connection dbname dbname server.example.com login_as_user

--login-path , --silent, --login-path /

Answer 4

mysql_config_editor, mysql

mysql_config_editor set --login-path=dev --user=dbuser --host=localhost -p

, ,

mysql --login-path=dev

Answer 5

Try:

if [ $MYSQL_PASS ]
then
  mysql -u "$MYSQL_ROOT" -p "$MYSQL_PASS" -e "SHOW DATABASES"
else
  mysql -u "$MYSQL_ROOT" -e "SHOW DATABASES"
fi

Answer 6

I'm not sure if this is possible, but you can definitely use the file configuration .