脚本代码如下：

#!/bin/bash
 
time=$(date "+%Y年%m月%d日 %A")
 
cho -e "\033[1;41m设置root账户密码...\033[0m"
mysqladmin -u root password '123456'
 
echo -e "\033[1;41m设置数据库权限...\033[0m"
 
# MySQL登录信息
USER="root"
PASSWORD="123456"
HOST="localhost"
 
# 创建用户并授予权限的SQL命令 
SQL_COMMAND_1="GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;"
SQL_COMMAND_2="GRANT ALL PRIVILEGES ON *.* TO 'game_db'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;"
SQL_COMMAND_3="GRANT ALL PRIVILEGES ON *.* TO 'game_db'@'127.0.0.1' IDENTIFIED BY '123456' WITH GRANT OPTION;"
SQL_COMMAND_4="FLUSH PRIVILEGES;"
 
# 执行MySQL命令
mysql -u$USER -p$PASSWORD -h$HOST -e "$SQL_COMMAND_1"
mysql -u$USER -p$PASSWORD -h$HOST -e "$SQL_COMMAND_2"
mysql -u$USER -p$PASSWORD -h$HOST -e "$SQL_COMMAND_3"
mysql -u$USER -p$PASSWORD -h$HOST -e "$SQL_COMMAND_4"
 
echo -e "\033[1;41m创建数据库和导入数据...\033[0m"
mysql -u root -p123456 -S /var/lib/mysql/mysql.sock -e "CREATE DATABASE game_db"
mysql -u root -p123456 -S /var/lib/mysql/mysql.sock dpcq_game < /root/dpcq_game.sql