mysql5.87 centos安装

 1.下载软件

yum remove mysql
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server
rpm -qa|grep mysql

设置密码

vim /etc/my.cnf

修改MySQL的配置文件（默认为/etc/my.cnf）,在[mysqld]下添加一行skip-grant-tables

保存配置文件后，重启MySQL服务 service mysqld restart

再次进入MySQL命令行 mysql -uroot -p,输入密码时直接回车，就会进入MySQL数据库了，这个时候按照常规流程修改root密码即可。注意密码有大小写字符，特殊字符

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

或

ALTER USER 'root'@'%' IDENTIFIED BY 'new_password'; 

设置可远程访问

grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option;

设置mysql可远程访问

FLUSH PRIVILEGES;

exit;

   service mysqld restart
   systemctl start mysqld.service
   service mysqld status