mysql - 避免第二次询问 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 凭据。有没有办法避免这种情况，一旦输入 root 密码，所有额外的 mysql 命令无缝执行？

Answer 1

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

[client]
user = root
password = XXXXXXXX

checkout :

How to execute a MySQL command from a shell script?