MySQL權限,mysql權限管理,mysql添加新使用者,mysql配置設定權限,mysql grant,mysql revoke

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 

原文：

https://blog.csdn.net/qq6759/article/details/81587925 

版權聲明：本文為部落客原創文章，轉載請附上博文連結！