Linux服务器上安装、卸载和配置MYSQL

Linux服务器上安装、卸载和配置MYSQL

在Linux服务器上安装、卸载和配置MySQL的详细步骤如下：

若未安装MySQL，执行以下命令：

rpm -qa | grep mysql

若结果显示未安装，执行以下命令安装MySQL：

wget -i -c https://repo.mysql.com/mysql80-community-release-el8-4.noarch.rpm

yum -y install mysql80-community-release-el8-4.noarch.rpm

yum -y install mysql-community-server

安装完成后，执行以下命令卸载MySQL：

systemctl stop mysqld.service

rpm -qa | grep mysql

执行rpm命令逐个卸载MySQL的组件：

rpm -ev mysql-community-server-8.0.31-1.el8.x86_64;

rpm -ev mysql-community-client-8.0.31-1.el8.x86_64;

rpm -ev mysql-community-libs-8.0.31-1.el8.x86_64;

rpm -ev mysql80-community-release-el8-4.noarch;

rpm -ev mysql-community-client-plugins-8.0.31-1.el8.x86_64;

rpm -ev mysql-community-common-8.0.31-1.el8.x86_64;

rpm -ev mysql-community-icu-data-files-8.0.31-1.el8.x86_64;

删除MySQL相关的文件夹：

rm -rf /usr/share/selinux/targeted/default/active/modules/100/mysql;

rm -rf /var/lib/mysql;

rm -rf /usr/lib64/mysql;

rm -rf /var/lib/selinux/targeted/active/modules/100/mysql;

删除配置文件：

rm -rf /etc/my.cnf

启动MySQL服务：

systemctl start mysqld.service

查看服务状态：

systemctl status mysqld.service

停止MySQL服务：

systemctl stop mysqld.service

检查初始密码，通常位于/var/log/mysqld.log文件中：

grep 'A temporary password' /var/log/mysqld.log

使用初始密码登录MySQL，然后修改密码：

ALTER USER USER() IDENTIFIED BY 'new password';

登录服务器的MySQL数据库并配置允许远程访问：

如果未允许远程登录，执行以下命令：

update user set host = '%' where user = 'root';

flush privileges;2024-11-06