MySQL各版本安装记录

5.7版本部署

RPM包部署

cd /usr/local/src
wget -q -i -c https://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
yum install mysql57-community-release-el7-10.noarch.rpm >/dev/null 2>&1
sed -i "s/gpgcheck=1/gpgcheck=0/g" /etc/yum.repos.d/mysql-community.repo >/dev/null 2>&1
yum -q -y install mysql-community-server >/dev/null 2>&1
systemctl -q start  mysqld.service
systemctl -q enable mysqld.service
# get mysql initial password.
grep "password" /var/log/mysqld.log > /root/mysqlinitialpasswd
sql_password=`cat /root/mysqlinitialpasswd |head -1 |awk '{print $NF}'`
# generate mysql new password.
new_sql_passwd=`mkpasswd -s 0`
echo "${new_sql_passwd}" > /root/newsqlpasswd
# make the new password effective.
mysqladmin -uroot -p${sql_password} password ${new_sql_passwd}

8.0版本部署

dnf部署

dnf install mysql84-community-release-el9-1.noarch.rpm
dnf config-manager --disable mysql-8.4-lts-community
dnf config-manager --enable mysql80-community
yum install mysql-community-server
systemctl start mysqld
grep 'temporary password' /var/log/mysqld.log

alter user 'root'@'localhost' identified by 'MySQL84!';
flush privileges;