Mysql添加用戶
使用可以對mysql數(shù)據(jù)庫用戶表有操作權(quán)限的用戶名登陸mysql
insert into user(Host,User,Password) values('%','name','password');
如果work用戶沒有登陸權(quán)限，則
killall mysqld
share/mysql/mysql.server start
grant all on *.* to work@'%' identified by "password";



MySQL賦予用戶權(quán)限的命令的簡單格式為
grant 權(quán)限 on 數(shù)據(jù)庫對象 to 用戶
grant 權(quán)限 on 數(shù)據(jù)庫對象 to 用戶 identified by "密碼"

用戶名:ad,密碼：ad_pass，登陸ip:192.168.0.10
//用戶在所有登陸ip的權(quán)限
grant all on *.* to ad@‘%’ identified by "ad_pass";

//開放管理MySQL中所有數(shù)據(jù)庫的權(quán)限
grant all on *.* to ad@'192.168.0.10' identified by "ad_pass";

//開放管理MySQL中具體數(shù)據(jù)庫(test)的權(quán)限
grant all privileges?on test to ad@'192.168.0.10' identified by "ad_pass";
或
grant all on test to ad@'192.168.0.10' identified by "ad_pass";

//開放管理MySQL中具體數(shù)據(jù)庫中的表(test.table1)的權(quán)限
grant all on test.table1 to ad@'192.168.0.10' identified by "ad_pass"

//開放管理MySQL中具體數(shù)據(jù)庫的表(test.table1)的部分列的權(quán)限
grant select(id,se,rank) on test.table1 to ad@'192.168.0.10' identified by "ad_pass";

//開放管理操作指令
grant select,insert,update,delete on test.* to ad@'192.168.0.10' identified by "ad_pass";

//回收權(quán)限
revoke all on *.* from ad@localhost;

//查看MySQL用戶權(quán)限
show grants;
show grants for ad@localhost;

mysql添加用戶和用戶權(quán)限