mysql数据库安装完成
1、设置root账号密码
alter user ‘root‘@‘localhost‘ identified by "123456";
update mysql.user set authentication_string=password(‘123456‘) where user=‘root‘ and Host = ‘localhost‘;
2、MySQL创建数据库：
CREATE DATABASE xm_user CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE xm_order CHARACTER SET utf8 COLLATE utf8_general_ci;
3、给数据库授权
grant all on xm_order.* to ‘user‘@‘%‘ identified by "u123456";
grant all on xm_user.* to ‘user‘@‘%‘ identified by "u123456";