MySQL添加新用户,为新用户分配权限,Mysql版本5.7
首先进入Mysql控制台：
mysql -uroot -p grant授权格式：grant 权限列表 on 库.表 to 用户名@'ip' identified by "密码";
创建一个新用户(user)并为此用户分配权限（这里先分配对所有数据库的表增删改查的权限），identified by 后面填入你新用户的密码
grant select,insert,update,delete on *.* to 'user'@'%' identified by 'your password'; 如果是给予全部权限那么就这样
grant all privileges on *.* to 'user'@'%' identified by 'your password'; 记得每次操作完要刷新授权
flush privileges; 查看用户权限
show grants for user; 回收权限，revoke回收权限格式：revoke 权限列表 on 库.表 from 用户名@'ip';
revoke select,insert,update,delete ON *.* from 'user'@'%'
操作权限列表 参考MySQL官网说明 Privileges Provided by MySQL
Table 6.2 Permissible Privileges for GRANT and REVOKE
Privilege Column Context ALL [PRIVILEGES] Synonym for “all privileges” Server administration ALTER Alter_priv Tables ALTER ROUTINE Alter_routine_priv Stored routines CREATE Create_priv Databases, tables, or indexes CREATE ROUTINE Create_routine_priv Stored routines CREATE TABLESPACE Create_tablespace_priv Server administration CREATE TEMPORARY TABLES Create_tmp_table_priv Tables CREATE USER Create_user_priv Server administration CREATE VIEW Create_view_priv Views DELETE Delete_priv Tables DROP Drop_priv Databases, tables, or views EVENT Event_priv Databases EXECUTE Execute_priv Stored routines FILE File_priv File access on server host GRANT OPTION Grant_priv Databases, tables, or stored routines INDEX Index_priv Tables INSERT Insert_priv Tables or columns LOCK TABLES Lock_tables_priv Databases PROCESS Process_priv Server administration PROXY See proxies_priv table Server administration REFERENCES References_priv Databases or tables RELOAD Reload_priv Server administration REPLICATION CLIENT Repl_client_priv Server administration REPLICATION SLAVE Repl_slave_priv Server administration SELECT Select_priv Tables or columns SHOW DATABASES Show_db_priv Server administration SHOW VIEW Show_view_priv Views SHUTDOWN Shutdown_priv Server administration SUPER Super_priv Server administration TRIGGER Trigger_priv Tables UPDATE Update_priv Tables or columns USAGE Synonym for “no privileges” Server administration --------------------- 作者：dongsir007 来源：CSDN 原文：blog.csdn.net/qq6759/arti… 版权声明：本文为博主原创文章，转载请附上博文链接！
首先进入Mysql控制台：
mysql -uroot -p grant授权格式：grant 权限列表 on 库.表 to 用户名@'ip' identified by "密码";
创建一个新用户(user)并为此用户分配权限（这里先分配对所有数据库的表增删改查的权限），identified by 后面填入你新用户的密码
grant select,insert,update,delete on *.* to 'user'@'%' identified by 'your password'; 如果是给予全部权限那么就这样
grant all privileges on *.* to 'user'@'%' identified by 'your password'; 记得每次操作完要刷新授权
flush privileges; 查看用户权限
show grants for user; 回收权限，revoke回收权限格式：revoke 权限列表 on 库.表 from 用户名@'ip';
revoke select,insert,update,delete ON *.* from 'user'@'%'
操作权限列表 参考MySQL官网说明 Privileges Provided by MySQL
Table 6.2 Permissible Privileges for GRANT and REVOKE
Privilege Column Context ALL [PRIVILEGES] Synonym for “all privileges” Server administration ALTER Alter_priv Tables ALTER ROUTINE Alter_routine_priv Stored routines CREATE Create_priv Databases, tables, or indexes CREATE ROUTINE Create_routine_priv Stored routines CREATE TABLESPACE Create_tablespace_priv Server administration CREATE TEMPORARY TABLES Create_tmp_table_priv Tables CREATE USER Create_user_priv Server administration CREATE VIEW Create_view_priv Views DELETE Delete_priv Tables DROP Drop_priv Databases, tables, or views EVENT Event_priv Databases EXECUTE Execute_priv Stored routines FILE File_priv File access on server host GRANT OPTION Grant_priv Databases, tables, or stored routines INDEX Index_priv Tables INSERT Insert_priv Tables or columns LOCK TABLES Lock_tables_priv Databases PROCESS Process_priv Server administration PROXY See proxies_priv table Server administration REFERENCES References_priv Databases or tables RELOAD Reload_priv Server administration REPLICATION CLIENT Repl_client_priv Server administration REPLICATION SLAVE Repl_slave_priv Server administration SELECT Select_priv Tables or columns SHOW DATABASES Show_db_priv Server administration SHOW VIEW Show_view_priv Views SHUTDOWN Shutdown_priv Server administration SUPER Super_priv Server administration TRIGGER Trigger_priv Tables UPDATE Update_priv Tables or columns USAGE Synonym for “no privileges” Server administration --------------------- 作者：dongsir007 来源：CSDN 原文：blog.csdn.net/qq6759/arti… 版权声明：本文为博主原创文章，转载请附上博文链接！
