mysql許可權

1,檢視所有使用者許可權

select distinct concat('User:''',user,'''@''',host,''';') AS query from mysql.user;

或者:

select * from mysql.user;

2,檢視某一個使用者的許可權

show grants for 'user'@'ip';

3,分配許可權(以selcet許可權為例)

--無須密碼

grant select on *.* to 'user'@'ip';

--指定密碼(xxxx為密碼)

grant select on *.* to 'user'@'ip'identified by 'xxxx';

4,回收許可權

revoke select on *.* from 'user'@'ip'identified by 'xxxx';

--暴利刪除某使用者的所有許可權

delete from mysql.user where User='user'

5,重新整理許可權,否則不生效

flushprivileges;

附,檢視當前埠

show global variables like 'port';

宵雲網路科技      webtfyum.net