参考链接:
https://jingyan.baidu.com/article/359911f59b00ae57ff030677.html
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
1、先参考链接https://jingyan.baidu.com/article/359911f59b00ae57ff030677.html
安装配置好mysql
2、登陆mysql增加用户和赋相应的权限
mysql -u root -p
3、修改root密码为Pa88w0rd@noah
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Pa88word@noah’;
4、创建远程登录用户root,密码Pa88w0rd@noah
CREATE USER ‘root’@’%’ IDENTIFIED BY ‘Pa88w0rd@noah’;
5、给远程用户root赋权,否则的话,不能建表和库
grant all privileges on . to ‘root’@’%’;
6、刷新权限列表
flush privileges;