Linux CentOS7 rpm 安装 MySQL 8.0.25

Linux CentOS7 rpm 安装 MySQL 8.0.25

一、参考资料

【MySQL数据库入门到大牛，mysql安装到优化，百科全书级，全网天花板】 https://www.bilibili.com/video/BV1iq4y1u7vj/?p=99&share_source=copy_web&vd_source=855891859b2dc554eace9de3f28b4528
MySQL rpm 安装包下载教程
VMvare 安装 CentOS 7 教程

二、笔记总结

2.1、检查权限和依赖

chmod-R777/tmprpm-qa|greplibaiorpm-qa|grepnet-tools

2.2、上传 rpm 安装包

2.3、安装 rpm 安装包

cd/opt/rpm-ivhmysql-community-common-8.0.25-1.el7.x86_64.rpmrpm-ivhmysql-community-client-plugins-8.0.25-1.el7.x86_64.rpm#安装第三个会报错rpm-ivhmysql-community-libs-8.0.25-1.el7.x86_64.rpm#执行这个命令解决报错yum remove mysql-libs#重新安装第三个rpm-ivhmysql-community-libs-8.0.25-1.el7.x86_64.rpmrpm-ivhmysql-community-client-8.0.25-1.el7.x86_64.rpmrpm-ivhmysql-community-server-8.0.25-1.el7.x86_64.rpm#检查安装结果rpm-qa|grep-imysql#初始化 MySQLmysqld--initialize--user=mysql#查看日志cat/var/log/mysqld.log

2.4、启动 MySQL

#启动 MySQLsystemctl start mysqld#查看 MySQL 运行状态systemctl status mysqld#检查是否开机启动systemctl list-unit-files|grepmysqld.service

2.5、修改密码和权限

#登录 MySQLmysql-uroot-p#修改默认密码alteruser'root'@'localhost'identifiedby'yyy123456.';#切换 MySQL 数据库usemysql;#查询用户信息selecthost,userfromuser;#运行远程连接updateusersethost='%'whereuser='root';#刷新权限flushprivileges;#取消密码加密alteruser'root'@'%'identifiedwithmysql_native_passwordby'yyy123456.';