mysql使用者權限操作

標籤：into   sele   查看   ant   drop   oca   val   使用者權限   密碼   

mysql使用者權限操作
1.建立使用者
mysql -uroot
create database zabbix default charset utf8;
grant all on zabbix.* to [email protected] identified by ‘zabbix‘;
#查看許可權
show grants for [email protected];
use mysql;
select * from user where User=‘zabbix‘\G
select Host,User from user where User=‘zabbix‘;

2.設定密碼
3.更改許可權

#建立user4使用者，並授權和配置密碼
GRANT SELECT,INSERT ON d3307.* TO [email protected]‘192.168.52‘ IDENTIFIED BY ‘user0523‘;
#查看使用者的對應許可權
SELECT * FROM mysql.`db` where user=‘user4‘\G

#CREATE建立使用者
create user ‘aaa01‘@‘localhost‘ identified by ‘aaa01‘,‘bbb01‘@‘localhost‘ identified by ‘bbb01‘;
#INSERT建立使用者
INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES(‘%’,’newuser1’,PASSWORD(‘123456’),”,”,”);
FLUSH PRIVILEGES;
#GRANT建立使用者
grant select,insert on db01.* to ‘aaa02‘@‘localhost‘ identified by ‘aaa02‘;

#DROP刪除使用者
drop user ‘aaa01‘@‘localhost‘;
#DELETE刪除使用者
DELETE FROM mysql.user WHERE Host = ‘%’ AND User = ‘admin’;

mysql使用者權限操作