@H_404_0@
@H_404_0@(2)安装过后需要启动MysqL服务 @H_404_0@service MysqLd start @H_404_0@如需重启: @H_404_0@service MysqLd restart
@H_404_0@
@H_404_0@(3)启动过后需要给MysqL创建一个root管理员 @H_404_0@MysqLadmin -u root password jereh123
@H_404_0@
@H_404_0@(4)进入MysqL @H_404_0@MysqL -u root -p
@H_404_0@
@H_404_0@(5)新增一个用户 @H_404_0@grant all on *.* to 'user'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
@H_404_0@二、后期遇到远程连接不上服务器上得MysqL @H_404_0@问题1:1130 host is not allowedto connect to this MysqL server @H_404_0@登录MysqL: @H_404_0@MysqL -u -p @H_404_0@执行命令: @H_404_0@grant all privileges on *.* to 'root'@'%' with grant option;
@H_404_0@flush privileges;
@H_404_0@exit; @H_404_0@
问题2:1045Access denied for user 'root'@'localhost' (using password: YES)
参考博客:http://www.cnblogs.com/qq78292959/p/3641972.html
1.停掉MysqL:
service MysqLd stop
2.使用如下命令并且结束
MysqLd_safe --user=MysqL --skip-grant-tables --skip-networking &
MysqL -u root -p
4.重新设置密码刷新并退出
UPDATE user SET Password=PASSWORD('cl155213') where USER='root';
FLUSH PRIVILEGES;
quit