一. 先使用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;