#!/bin/bash
#########################################
#Function:    dedecms_create_mysql_user
#Usage:       bash dedecms_create_mysql_user.sh
#Version:     1.0  2024.05.09
#Blog:        http://www.19aq.com/
#Team:        Roots Exploits Team
#########################################
DIR=/www/wwwroot/
DATA=$(ls -l "$DIR" | awk '{print$9}')
error_handler() {
    echo "mysql数据库 无法建立/无权限等"
    exit 1
}
for i in $DATA
do
    CUR_DIR=$DIR$i
    PC_FILE="$CUR_DIR/data/common.inc.php"
    if [ -f "$PC_FILE" ]; then
        # 如果存在,进行重写
        NAME="${i//[-.]/_}"
        NAME="${NAME,,}"
        trap 'error_handler' ERR
        SQL_COMMAND="CREATE DATABASE IF NOT EXISTS $NAME DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;"
        mysql -uc32 -pc32 -e"$SQL_COMMAND"
        CC_VALUE="${NAME//_/\\_}"
        SQL_COMMAND="CREATE USER '$NAME'@'localhost' IDENTIFIED BY '$NAME';"
        mysql -uc32 -pc32 -e"$SQL_COMMAND"
        SQL_COMMAND="GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON \`$CC_VALUE\`.* TO '$NAME'@'localhost';"
        mysql -uc32 -pc32 -e"$SQL_COMMAND"
        SQL_COMMAND="GRANT GRANT OPTION ON \`$CC_VALUE\`.* TO '$NAME'@'localhost';"
        mysql -uc32 -pc32 -e"$SQL_COMMAND"
        echo $NAME"----create mysql user success"
    fi
done