mysql create user and grant

2018-03-08 本文已影响0人三哥那多曼

create database xxx;
CREATE USER 'jeffrey'@'localhost'
IDENTIFIED BY 'new_password' ;
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
flush privileges;