centos安装多个版本的mysqlCentOS7卸载mysql5或者MySQL8并重新安装MySQL8

导读#头条创作挑战赛#先看结果，最后再说遇到的情况，接下来我们就来聊聊关于centos安装多个版本的mysql?以下内容大家不妨参考一二希望能帮到您!cento....

#头条创作挑战赛# 先看结果，最后再说遇到的情况，接下来我们就来聊聊关于centos安装多个版本的mysql?以下内容大家不妨参考一二希望能帮到您!

centos安装多个版本的mysql

#头条创作挑战赛# 先看结果，最后再说遇到的情况。

卸载 MySQL5或者MySQL8

#1. 停止MySQL服务systemctl stop mysqld #2. 查询MySQL的安装文件rpm -qa | grep -i mysql #3. 卸载上述查询出来的所有的MySQL安装包# mysql-x.x.x.x 是第二步查出来的内容，从下往上一个一个进行处理。rpm -e --nodeps mysql-x.x.x.x #4. 删除MySQL的数据存放目录rm -rf /var/lib/mysql/ #5. 删除MySQL的配置文件备份rm -rf /etc/my.cnf.rpmsave

安装 MySQL8

cd /home/mkdir mysql8cd mysql8wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.30-1.el7.x86_64.rpm-bundle.tartar -xvf mysql-8.0.30-1.el7.x86_64.rpm-bundle.taryum -y install glibcyum -y install glibc-static libstdc -staticyum -y install libaioyum -y remove mysql-libschattr -i /etc/passwd;chattr -i /etc/shadow;chattr -i /etc/group;chattr -i /etc/sudoersgroupadd mysqluseradd mysql -g mysql -M -s /sbin/nologinrpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpmrpm -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-compat-8.0.30-1.el7.x86_64.rpmrpm -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpmrpm -ivh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpmrpm -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpmcp -r /var/lib/mysql /home/data/chown mysql:mysql -R /home/data/mysql /home/logs/mysql/cat>/etc/my.cnf<<EOF[mysqld]datadir=/home/data/mysql/datasocket=/home/data/mysql/mysql.socklog-error=/home/data/mysql/mysqld.logpid-file=//home/data/mysql/mysqld.pidexplicit_defaults_for_timestamp=truecharacter-set-server = utf8mb4collation-server = utf8mb4_general_cilower_case_table_names = 1sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE#plugin-load=validate_password.so #validate-password=OFFlog-bin = /home/logs/mysql/mysql-bin.logexpire-logs-days = 14server-id = 1join_buffer_size = 128Mtmp_table_size = 128Msort_buffer_size = 128Mread_buffer_size = 256Mread_rnd_buffer_size = 128M#innodb_log_file_size = 2Ginnodb_log_buffer_size = 8Minnodb_buffer_pool_size = 500Mmax_connections=1000wait_timeout=31536000interactive_timeout=31536000[mysql]socket=/home/data/mysql/mysql.sock[client]socket=/home/data/mysql/mysql.sock[mysqldump]socket=/home/data/mysql/mysql.sock[mysqladmin]socket=/home/data/mysql/mysql.sockEOFcd /home/data/mysql/# 这里需要注意，要创建一个mysql的log文件，并且给mysql用户权限。vi mysqld.logchown -Rf mysql.mysql mysqld.logchmod 755 mysqld.logmysqld --initialize --user=mysqlsystemctl start mysqldsystemctl status mysqldsystemctl enable mysqldcat mysqld.log | grep passwordmysql -u root -puse mysql;ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY "Aa123456";flush privileges;

以上脚本代码，复制粘贴执行就行，在mysql8.0.31上测试有点问题，还没有调整。在mysql8.0.30版本测试通过。