MySQL授权
S1.授权命令
grant ${权限类型} on ${数据库名}.${表名} to ${用户名}@'${允许登录的客户端地址}' identified by '${登录密码}';
${允许登录的客户端地址}:
- 允许所有客户端登录,则使用:%
- 允许本地登录,则使用:localhost
- ...
权限类型:
* all: 所有权限
* select/insert/update/delete: 查询/增加/修改/删除权限
* ...
举例: grant all on *.* to root@'%' identified by 'Xxxxxxxx';
S2.使权限修改立即生效
flush privileges;