centos7 mysql5.7.rpm安装

1.检查是否安装了 mysql

  rpm -qa | grep mysql

2.下载

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

3.如果遇到 -bash:wget:未找到命令

 	安装插件 yum-y install || wget

4.安装mysql-community-release-e17-5.noarch.rpm包

	sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm 

5.安装mysql

    sudo yum install mysql-server

6.重置mysql密码

	mysql -u root
	ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
	原因：/var/lib/mysql/的访问权限的问题
	chown root /var/lib/mysql/

7.重启mysql

	service mysqld restart

8.登陆设置密码

	 mysql -u root
	 use mysql;
	 update user set password=password('123456') where user = 'root'
	 exit;
	 继续重启mysql
	 service mysqld restart

9.配置远程连接

	开启防火墙mysql3306端口的外部访问
		[root@localhost ~]$ firewall-cmd --zone=public --add-port=3306/tcp --permanent
		[root@localhost ~]$ firewall-cmd --reload
		
	mysql -u root -p
	grant all privileges  on *.* to root@'%' identified by "root";
	继续重启mysql
	service mysqld restart

10.配置开机启动

 	vim /etc/rc.loca
    添加service mysqld start