Mysql创建数据库及对应账户

1.登录数据库

 mysql -u root -p

2.创建数据库

 create database Mymall charset=utf8;

3.创建能够访问Mymall数据库的账号

 create user MymallUser identified 'MymallUser的密码';

4.授予权限给MymallUser访问Mymall数据库

 grant all on mymall.* to 'MymallUser'@'%';

5.刷新权限

 flush privileges;