引言
前提条件
- CentOS系统环境
- 已安装MySQL官方源码
- 良好的Linux基础
步骤一:卸载MySQL
- 查询MySQL安装信息:
rpm -qa | grep mysql
- 卸载已安装的MySQL包:
rpm -e mysql-community-server rpm -e mysql-community-client rpm -e mysql-community-libs
- 清理残留文件和配置:
find / -name 'mysql' -exec rm -rf {} \; rm -rf /etc/my.cnf
步骤二:手动卸载依赖库
- 查询系统中的依赖库:
yum list installed | grep mysql
- 卸载依赖库:
yum remove mysql-community-libs yum remove mysql-community-client yum remove mysql-community-server
步骤三:手动卸载MySQL客户端
- 查询客户端安装信息:
rpm -qa | grep mysql
- 卸载客户端:
rpm -e mysql-community-client
步骤四:创建MySQL用户和用户组
- 添加MySQL用户组:
groupadd mysql
- 添加MySQL用户:
useradd -r -g mysql mysql
步骤五:安装MySQL官方源码
- 下载MySQL官方源码:
wget https://dev.mysql.com/get/mysql-8.4.3-1.el7.x86_.tar.gz
- 解压源码:
tar -zxvf mysql-8.4.3-1.el7.x86_.tar.gz
- 切换到源码目录:
cd mysql-8.4.3-1.el7.x86_
- 编译安装:
cmake . make make install
步骤六:配置MySQL
- 配置MySQL:
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
- 修改权限:
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服务
- 查看MySQL状态:
service mysqld status
- 连接MySQL数据库:
mysql -u root -p
总结
通过以上步骤,您可以在CentOS系统上成功卸载官方源码安装的MySQL,并重新进行安装和配置。这样不仅避免了依赖问题,还能实现高效部署。希望本文能对您有所帮助!