mysql权限管理

添加登录账户语法: grant 权限 on 所有库表或部分库表 to '登录时账号名'@'指定主机，ip' identified by '登录时所需密码' 1.所有库和表 grant all on *.* to 'username'@'ip' identified by '123456'; flush privileges; 2.指定库所有表 grant all on dbname.* to 'username'@'ip' identified by '123456'; flush privileges; 3.指定库指定表 grant all on dbname.table to 'username'@'ip' identified by '123456'; flush privileges; 4.指定库指定表指定权限(以更新权限为例） grant update on dbname.table to 'username'@'ip' identified by '123456'; flush privileges;