centos7安装mysql5.7jack的博客-

一.首先切换至root用户:

sudo su root  

已经是root用户则不需要

二.选择想安装的其中一个版本进行下载安装:

5.7自定义存档version(小于5.7.30):

version=5.7.25 mkdir -pv  /tmp/mysql && cd /tmp/mysql &&  echo -n https://cdn.mysql.com/archives/mysql-5.7/mysql-community- {client,server,common,libs}-$version-1.el7.x86_64.rpm | xargs -i -d " " curl -O {} &&  rpm -e --nodeps $(rpm -qa|grep mariadb) ; yum -y install $(ls | grep ".rpm") &&  mysqld --user=mysql --initialize --datadir=/var/lib/mysql/ 

5.7最新版本为5.7.30:(最新版与存档版url不一样)

mkdir -pv  /tmp/mysql && cd /tmp/mysql &&  echo -n https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community- {client,server,common,libs}-5.7.30-1.el7.x86_64.rpm  | xargs -i -d " " curl -O {} &&  rpm -e --nodeps $(rpm -qa|grep mariadb) ; yum -y install $(ls | grep ".rpm") &&  mysqld --user=mysql --initialize --datadir=/var/lib/mysql/ 

三.备份配置 :

cp /etc/my.cnf /etc/my.cnf.bak

四.修改配置:

sed "/[mysqld]/aport=3306ndatadir=/var/lib/mysqlnmax_connections=200n character-set-server=utf8ndefault-storage-engine=INNODBnlower_case_table_names=1n max_allowed_packet=16Mnexplicit_defaults_for_timestamp=truendefault_password_lifetime=0"  /etc/my.cnf.bak > /etc/my.cnf && systemctl enable mysqld --now ; systemctl status mysqld

五.找到初始密码登录:

grep 'temporary password' /var/log/mysqld.log && mysql -uroot -p

六.修改新密码:

use mysql; ALTER USER "root"@"localhost" IDENTIFIED BY "12345678"; flush privileges;