Mysql 创建用户

mysql 常用命令

#### 网上有很多这些方法生成强密码
< /dev/urandom tr -dc 0-9-A-Z-a-z |head -c ${1:-20};echo

echo $(uuidgen | awk -F '-' '{print $1}')$(uuidgen | awk -F '-' '{print $1}')

date +%s |sha256sum |base64 |head -c 20 ;echo

创建用户

# 管理员权限： all privileges
GRANT select,create,delete,update ON {db}.* TO '{user}'@'%' IDENTIFIED BY '{password}';
flush privileges;

创建只读账号

GRANT select ON {db}.* TO 'read'@'{host}' IDENTIFIED BY '{password}';
flush privileges;

删除用户

drop user '{user}'@'{host}';
flush privileges;

查看用户权限

show grants for {user};

# 授权
grant insert on {db}.* to '{user}'@'%';
show grants for '{user}'@'%';