数据库版本:mysql5.7
开发环境:ubuntu16.04
#!/bin/bash
#用以登录的ip和用户名
hostname=localhost
username=root
port=3306
#需要创建的用户名及密码
user1=hello
password1=123123!8080
user2=world
password2=123123!7070
read -p "请输入root用户密码:" password
mysql --host=$hostname --user=$username --password=$password --port=$port <<EOF
GRANT ALL PRIVILEGES ON 数据库名.表名 TO '$user1'@'%' IDENTIFIED BY '$password1' REQUIRE X509;
GRANT ALL PRIVILEGES ON 数据库名.表名 TO '$user2'@'%' IDENTIFIED BY '$password2' REQUIRE X509;
EOF