wvp/package/updateSqlImage.sh

#!/bin/bash

# 加载配置文件
source ./config.cfg
# 检查必要启动参数是否存在
if [ "$enable_sql" == "1" ];then
    echo "等待sql启动"
    docker ps -a | grep hfysql
    if [ $? -eq 0 ]; then
        # 导出数据库
        echo "mysql 数据库已经启动"
    else
        echo "mysql 数据库启动失败"
        docker logs hfysql
        exit 1
    fi
    #  修改数据库名,无法修改数据库名,拒绝操作
#    docker exec -it hfysql mysql \
#     -uroot -p"hfy$sql_passwd" \
#     -e "ALTER DATABASE gb_db TO $sql_db;"
    # 创建单独用户
    docker exec -it hfysql mysql \
     -uroot -p"hfy$sql_passwd" \
     -e "CREATE USER '$sql_user'@'%' IDENTIFIED BY '$sql_passwd';"
    # 不限制ip访问
    docker exec -it hfysql mysql \
      -uroot -p"hfy$sql_passwd" \
      -e "GRANT ALL PRIVILEGES ON $sql_db.* TO '$sql_user'@'%';"
    # 刷新权限
    docker exec -it hfysql mysql \
      -uroot -p"hfy$sql_passwd" \
      -e "FLUSH PRIVILEGES;"

fi