grant all privileges on databasename.tablename to 'username'@'%' identified by 'password';
flush privileges;
如:
grant all privileges on hd_basic.* to 'basic'@'%' identified by 'basic123';
-- 刷新生效
flush privileges;
grant all privileges on databasename.tablename to 'username'@'%' identified by 'password';
flush privileges;
如:
grant all privileges on hd_basic.* to 'basic'@'%' identified by 'basic123';
-- 刷新生效
flush privileges;