mysql创建用户权限

INSERT INTO mysql.user(HOST,USER,PASSWORD) VALUES("localhost","exam",PASSWORD("exam"));

FLUSH PRIVILEGES;


CREATE DATABASE ecm

GRANT ALL PRIVILEGES ON ecm.* TO exam@localhost IDENTIFIED BY 'exam';

原文地址:https://www.cnblogs.com/bigcelestial/p/3305018.html