引言

前提条件

  • CentOS系统环境
  • 已安装MySQL官方源码
  • 良好的Linux基础

步骤一:卸载MySQL

  1. 查询MySQL安装信息:
    
    rpm -qa | grep mysql
    
  2. 卸载已安装的MySQL包:
    
    rpm -e mysql-community-server
    rpm -e mysql-community-client
    rpm -e mysql-community-libs
    
  3. 清理残留文件和配置:
    
    find / -name 'mysql' -exec rm -rf {} \;
    rm -rf /etc/my.cnf
    

步骤二:手动卸载依赖库

  1. 查询系统中的依赖库:
    
    yum list installed | grep mysql
    
  2. 卸载依赖库:
    
    yum remove mysql-community-libs
    yum remove mysql-community-client
    yum remove mysql-community-server
    

步骤三:手动卸载MySQL客户端

  1. 查询客户端安装信息:
    
    rpm -qa | grep mysql
    
  2. 卸载客户端:
    
    rpm -e mysql-community-client
    

步骤四:创建MySQL用户和用户组

  1. 添加MySQL用户组:
    
    groupadd mysql
    
  2. 添加MySQL用户:
    
    useradd -r -g mysql mysql
    

步骤五:安装MySQL官方源码

  1. 下载MySQL官方源码:
    
    wget https://dev.mysql.com/get/mysql-8.4.3-1.el7.x86_.tar.gz
    
  2. 解压源码:
    
    tar -zxvf mysql-8.4.3-1.el7.x86_.tar.gz
    
  3. 切换到源码目录:
    
    cd mysql-8.4.3-1.el7.x86_
    
  4. 编译安装:
    
    cmake .
    make
    make install
    

步骤六:配置MySQL

  1. 配置MySQL:
    
    ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
    
  2. 修改权限:
    
    chown -R mysql:mysql /usr/local/mysql/
    chown -R mysql:mysql /usr/local/mysql/data
    

步骤七:启动MySQL服务

    创建服务文件:

    
    vi /etc/init.d/mysqld
    

    添加以下内容:

    #!/bin/bash
    # Start/Stop mysqld server
    # chkconfig: 2345 75 25
    # description: The MySQL server
    # processname: mysqld
    # config: /etc/my.cnf
    # Source function library.
    . /etc/init.d/functions
    # Source networking configuration.
    . /etc/sysconfig/network
    . /etc/sysconfig/network-functions
    # Check that networking is up
    if [ "$NETWORKING" = "no" ]; then
     exit 0
    fi
    # Start daemons.
    start {
     daemon $DAEMON
     echo -n "$DAEMON"
     return 0
    }
    # Stop daemons.
    stop {
     # reload -q
     killproc $DAEMON
     echo -n "$DAEMON"
     return 0
    }
    # Restart daemons.
    restart {
     stop
     start
    }
    # You can insert your own commands here.
    # See 'man chkconfig' for details.
    

    使服务文件可执行:

    chmod +x /etc/init.d/mysqld
    

    添加服务到系统:

    chkconfig --add mysqld
    

    启动服务:

    service mysqld start
    

步骤八:验证MySQL服务

  1. 查看MySQL状态:
    
    service mysqld status
    
  2. 连接MySQL数据库:
    
    mysql -u root -p
    

总结

通过以上步骤,您可以在CentOS系统上成功卸载官方源码安装的MySQL,并重新进行安装和配置。这样不仅避免了依赖问题,还能实现高效部署。希望本文能对您有所帮助!