本文主要演示在Linux系统上如何安装MySQL最新版本MySQL 8.0
自带MySQL卸载
安装前,我们可以检测系统是否自带安装 MySQL,如果自带安装,那么卸载原来安装的MySQL
rpm -qa | grep mysql
如果显示安装了MySQL,那么可以卸载
我们系统显示如上,那么我们通过如下命令将已安装的信息卸载(当然这一步视不同情况而定,如果你的机器上尚未安装,则可跳过此步骤)
停止mysql服务、删除之前安装的mysql
删除命令:
rpm -e –nodeps 包名
rpm -ev mysql80-community-release-el7-1.noarch
rpm -ev akonadi-mysql-1.9.2-4.el7.x86_64
rpm -ev qt-mysql-4.8.5-13.el7.x86_64
如果提示依赖包错误,则使用以下命令尝试
rpm -ev perl-DBD-MySQL-4.023-5.el7.x86_64 --nodeps
如果提示错误:error: %preun(xxxxxx) scriptlet failed, exit status 1
则用以下命令尝试:
rpm -e --noscripts qt-mysql-4.8.5-13.el7.x86_64
查找之前老版本mysql的目录、并且删除老版本mysql的文件和库
find / -name mysql
查找结果如下
/etc/selinux/targeted/active/modules/100/mysql
/etc/selinux/targeted/tmp/modules/100/mysql
/root/.local/share/akonadi/db_data/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql
/data/mysql
删除对应的mysql目录(删除根据自己系统上的目录进行删除,示例是笔者系统的目录)
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rm -rf /etc/selinux/targeted/tmp/modules/100/mysql
rm -rf /root/.local/share/akonadi/db_data/mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql/mysql
rm -rf /usr/lib64/mysql
rm -rf /data/mysql
安装 MySQL
1、去官网下载Yum 资源包
mkdir /data/mysql
cd /data/mysql
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
yum install mysql-server
启动 MySQL
systemctl start mysqld
查看 MySQL 运行状态
systemctl status mysqld
# 获取临时密码
grep 'temporary password' /var/log/mysqld.log
# 使用临时密码登录
mysql -u root -p
# 修改root账户的密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
开机自动启动mysql
vim /etc/rc.local
添加
systemctl status mysqld
设置mysql允许远程连接
mysql> CREATE USER 'client'@'%' IDENTIFIED WITH mysql_native_password BY 'MyNewPass4!';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'client'@'%' WITH GRANT OPTION;
防火墙设置
开启端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙
firewall-cmd --reload