【MySQL】linux环境安装mysql 8.0.25

  1. 下载安装包mysql-8.0.25-1.el7.x86_64.rpm-bundle.tar,解压后,选择下列5个文件,上传至/opt
mysql-community-common-8.0.25-1.el7.x86_64
mysql-community-libs-8.0.25-1.el7.x86_64
mysql-community-client-plugins-8.0.25-1.el7.x86_64
mysql-community-client-8.0.25-1.el7.x86_64
mysql-community-server-8.0.25-1.el7.x86_64
  1. 依次安装
rpm -ivh mysql-community-common-8.0.25-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-plugins-8.0.25-1.el7.x86_64.rpm

yum remove mysql-libs
rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.25-1.el7.x86_64.rpm

yum install libaio
rpm -ivh mysql-community-server-8.0.25-1.el7.x86_64.rpm
  1. 初始化
mysqld --initialize --user=mysql
  1. 查看默认密码
cat /var/log/mysqld.log
  1. 启动
systemctl start mysqld
  1. 登录
mysql -u root -p
  1. 重置密码
alter user root@localhost identified by 123456;
  1. 设置root可远程登录
use mysql;
update user set Host = % where User = root;
flush privileges;
经验分享 程序员 微信小程序 职场和发展