Centos7.9安装mysql8.2记录
第一步,卸载mariadb
rpm -qa | grep mariadb #检查是否有MariaDB
mariadb-libs-5.5.68-1.el7.x86_64
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64 #删除
rpm -qa | grep mariadb #结果确认
第二,下载和解压安装包
(官网链接)
先选择合适的版本,点击download处,右键复制连接
得到下载地址:https://downloads.mysql.com/archives/get/p/23/file/mysql-8.2.0-1.el7.x86_64.rpm-bundle.tar
下载
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.2.0-1.el7.x86_64.rpm-bundle.tar
等待下载完成
解压文件
tar -xvf mysql-8.2.0-1.el7.x86_64.rpm-bundle.tar
第三步、安装依赖和主程序
1、安装依赖
yum install -y libaio
yum install -y net-tools
yum install openssl-devel.x86_64 openssl.x86_64 -y
yum -y install autoconf
yum install perl.x86_64 perl-devel.x86_64 -y
yum install perl-JSON.noarch -y
yum install perl-Test-Simple -y
2、按顺序安装主程序
rpm -ivh mysql-community-common-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.2.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.2.0-1.el7.x86_64.rpm
第四步、启动和初始配置
启动,加入开机启动项,查看状态。不报错即为OK。
systemctl start mysqld.service
systemctl enable mysqld.service
systemctl status mysqld.service
查找初始密码
cat /var/log/mysqld.log | grep 'temporary password'
登陆mysql,修改密码
mysql -u root -p
Enter password:tf:wm)lOM0Kt
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aa@123456!'; #修改初始密码
FLUSH PRIVILEGES; #刷新系统
set global validate_password.policy=0; #设置安全级别为低
set global validate_password.length=6; #设置长度为6
FLUSH PRIVILEGES; #刷新系统
SHOW VARIABLES LIKE 'validate_password%'; #查看密码复杂度
ALTER USER 'root'@'localhost' IDENTIFIED BY 'A11111'; #按需设置密码
FLUSH PRIVILEGES; #刷新系统
exit; #退出
备注
如果遇到错误,直接对应查询错误代码。本人第一次时遇到了较多错误,特意做了整理,按照整理教程无错误。具体因版本而已。
重置密码参考:
https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/134683487
如果登陆提示错误1045,参考教程
https://blog.csdn.net/m0_64304713/article/details/133975710