CREATE USER 'theKingOfNight'@'localhost' IDENTIFIED BY 'password';
这里localhost也可以换成%,也就是可以远程登录
GRANT ALL ON database.tadabase TO 'theKingOfNight'@'localhost';
权利一般有select,update,insert等,可以设置为all
flush privileges
立即生效
CREATE USER 'theKingOfNight'@'localhost' IDENTIFIED BY 'password';
这里localhost也可以换成%,也就是可以远程登录
GRANT ALL ON database.tadabase TO 'theKingOfNight'@'localhost';
权利一般有select,update,insert等,可以设置为all
flush privileges
立即生效