1.去下面列表页面下载MySql的rpm包 选择自己对应的版本
https://dev.mysql.com/downloads/mysql/
2.在linux服务器上下载文件
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar
//下载之后开始解压文件
tar -xvf mysql-8.0.30-1.sl15.x86_64.rpm-bundle.tar
//解压之后得到几个rpm文件。依次安装他们
rpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm
yum install net-tools
rpm -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpm
# 启动mysql数据库
systemctl start mysqld
查看临时密码
grep “A temporary password” /var/log/mysqld.log
此时可以看到mysql的临时密码,登陆上去修改
[root@localhost ~]# grep “A temporary password” /var/log/mysqld.log
2022-08-22T15:47:46.261021Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ebDgCiXfj8,X
mysql -u root -p
进入mysql后,修改密码。刷新权限
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码' PASSWORD EXPIRE NEVER;
最后可选操作。打开远程连接
use mysql;
update user set host="%" where user="root";
操作完成后刷新权限
FLUSH PRIVILEGES;
评论区