linux yum mysql 安装

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

yum -y localinstall mysql57-community-release-el7-11.noarch.rpm 

yum -y install mysql-community-server

systemctl start mysqld

vi /var/log/mysqld.log //找到临时密码 
vi /etc/my.cnf 最后一行添加skip-grant-tables //免密码登录
               character_set_server=utf8  //全局修改字符编码

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Gxk2018@';//修改密码

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload

版本升级
mysql_upgrade -u root -p --force