create database xxx;
CREATE USER 'jeffrey'@'localhost'
IDENTIFIED BY 'new_password' ;
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
flush privileges;
create database xxx;
CREATE USER 'jeffrey'@'localhost'
IDENTIFIED BY 'new_password' ;
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
flush privileges;
本文标题:mysql create user and grant
本文链接:https://www.haomeiwen.com/subject/betyfftx.html
网友评论