-- 赋予某个库全部权限

use mysql;

grant all privileges on test_db.* to test_user@'%' identified by 'Aa123456';

grant all privileges on test_db.* to test_user@'localhost' identified by 'Aa123456';

flush privileges;

 

-- 赋予某个库增删改查权限

use mysql;

grant select,insert,update,delete on test_db.* to test_user@'%' identified by 'Aa123456';

grant select,insert,update,delete on test_db.* to test_user@'localhost' identified by 'Aa123456';

flush privileges;