DSP

MySQL为新建用户添加权限

2019-07-13 09:32发布

GRANT USAGE ON *.* TO 'dsp'@'%' IDENTIFIED BY 'dsp' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.*  TO 'dsp'@'%' IDENTIFIED BY 'dsp';