Linux安装MySQL5.7

• 卸载Linux自带的mariadb

//查看
rpm -qa | grep mariadb
//卸载
rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64
// 删除etc目录下的my.cnf
rm /etc/my.cnf

1. 下载并安装MySQL官方的 Yum Repository

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2. 安装

yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

3.启动MySQL

systemctl start  mysqld.service
//查看MySQL运行状态
systemctl status mysqld.service

4.修改密码

//获取密码
grep "password" /var/log/mysqld.log
//进入数据库
mysql -uroot -p
//修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

5. 开启mysql的远程访问

//下面命令开启的IP是 192.168.0.1，如要开启所有的，用%代替IP
grant all privileges on *.* to 'root'@'192.168.0.1' identified by 'password' with grant option;
flush privileges; 
exit;

6.开放端口

• etc/sysconfig 录下的iptables文件里添加新的开放端口
  
• 重新加载配置文件

service iptables restart

7.修改mysql的字符编码（不修改会产生中文乱码问题

//显示原来编码：
show variables like '%character%';
//修改/etc/my.cnf
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'

注意：如果远程连不上数据库可以修改权限

update user set host='%' where user='root';
flush privileges;