#创建数据库
create database ‘数据库名’;
#创建新用户 dyd ,密码是 1234
CREATE USER 'dyd '@'localhost' IDENTIFIED BY '1234';
#为用户授权
grant all privileges on ec_db.* to 'dyd '@'localhost' identified by 'dyd ';
#刷新权限
flush privileges;
create database ‘数据库名’;
#创建新用户 dyd ,密码是 1234
CREATE USER 'dyd '@'localhost' IDENTIFIED BY '1234';
#为用户授权
grant all privileges on ec_db.* to 'dyd '@'localhost' identified by 'dyd ';
#刷新权限
flush privileges;