mysql怎么创建用户并给用户授权
1.创建用户U1
create user ‘U1’@’%’ identified by ‘mysql’; /mysql为密码/
2.开始授权
语法:grant 权限 on 数据库名.表名 to ‘用户名’ @ ‘%’ [identified by 密码]
例如:
grant all privileges on test.* to ‘U1’@’%’ with grant option; /with grant option 为允许用户U1将此权限转给别人/
注:如果之前对数据库里的表进行过改动,则要先执行flush privileges更新权限,再进行授权