1 创建账号
#本地账号 create user ‘root‘@‘localhost‘ identified by ‘password‘; #mysql -uroot -p123 #远程账号 create user ‘root‘@‘192.168.31.10‘ identified by ‘password‘; #mysql -uroot -p123 -h create user ‘root‘@‘192.168.31.%‘ identified by ‘password‘; #mysql -uroot -p123 -h create user ‘root‘@‘%‘ identified by ‘password‘; #mysql -uroot -p123 -h
2 授权
user: *.*
db: db1.*
tables_priv: db1.t1
columns_priv:id,name
原文：https://www.cnblogs.com/zhujing666/p/12316473.html