可以。这样做:
GRANT SELECT,INSERT,UPDATE,DELETE,CAREATE,DROP ON dbname.* TO user@localhost IDENTIFIED BY 'password';
或者
GRANT SELECT,INSERT,UPDATE,DELETE,CAREATE,DROP ON dbname.* TO [email protected].% IDENTIFIED BY 'password';
或者
GRANT SELECT,INSERT,UPDATE,DELETE,CAREATE,DROP ON dbname.* TO user@% IDENTIFIED BY 'password';
这里SELECT,INSERT,UPDATE......你任意选。GRANT ALL ON dbname.* TO user@localhost IDENTIFIED BY 'password';
这是把所有的权限都给user
GRANT SELECT,INSERT,UPDATE,DELETE,CAREATE,DROP ON dbname.* TO user@localhost IDENTIFIED BY 'password';
或者
GRANT SELECT,INSERT,UPDATE,DELETE,CAREATE,DROP ON dbname.* TO [email protected].% IDENTIFIED BY 'password';
或者
GRANT SELECT,INSERT,UPDATE,DELETE,CAREATE,DROP ON dbname.* TO user@% IDENTIFIED BY 'password';
这里SELECT,INSERT,UPDATE......你任意选。GRANT ALL ON dbname.* TO user@localhost IDENTIFIED BY 'password';
这是把所有的权限都给user
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货