避免再次询问mysql root密码(bash)

Question

在如下所示的简单脚本中：

set -x
# Check if db exists, if not we make it, make user, give privileges
if ! mysql -u root -p -e "use $db" 2>/dev/null; then

    c1="CREATE DATABASE $db"
    c2="GRANT ALL PRIVILEGES ON ${db}.* to '$username'@'localhost' IDENTIFIED BY '$password'"
    c3="FLUSH PRIVILEGES"

    mysql -u root -p -e "$c1; $c2; $c3"
else
    echo 'DATABASE ExISTS, ABORTING'; exit $DB_EXISTS
fi

每次bash看到mysql命令时，都会询问我的根凭据。有没有办法避免这种情况，这样一旦输入root密码，所有附加的mysql命令就可以无缝执行了？

Answer 1

尝试将密码添加到~/.my.cnf

[client]
user = root
password = XXXXXXXX

查看：

How to execute a MySQL command from a shell script?

Answer 2

指定密码--参数

mysql -u root --password=my_mysql_pass db_name

使用bash变量更安全

mysql -u root --password=$MYSQL_PASS db_name