一. 先使用root賬號登錄
mysql -u root -p
use mysql;
insert into user(host,user,password) values('localhost','abc',password('123'));
flush privileges;
先切換到mysql數(shù)據(jù)庫臣嚣，
在向user表添加用戶為abc的數(shù)據(jù)多艇。
二. 給abc用戶設(shè)置權(quán)限
如賦予abc用戶aaa數(shù)據(jù)庫的test1表的select和test2表的insert, select
GRANT select ON aaa.test1 TO 'abc'@'localhost' IDENTIFIED by '123';
GRANT select,insert ON aaa.test2 TO 'abc'@'localhost' IDENTIFIED by '123';
flush privileges;
