RPM方式部署MySQL
一、下载rpm包
wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm
yum install -y mysql80-community-release-el7-4.noarch.rpm
ls /etc/yum.repos.d/ #查看yum仓库
CentOS-Base.repo CentOS-Media.repo mysql-community.repo
CentOS-CR.repo CentOS-Sources.repo mysql-community-source.repo
二、安装
yum -y install mysql-community* #要进入到wget下载的rpm包目录下执行
三、多种登录方式
(1)可以设置本机免密登录数据库,进去后进行修改密码(不推荐)
设置MySQL免密登录
在[mysqld]最后添加:skip-grant-tables
(2)查看临时密码(推荐)
grep 'temporary password' /var/log/mysqld.log
2021-11-15T03:19:49.184227Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ZrWOG*fKy2M)
修改root密码
修改root用户密码: alter user'root'@'localhost' identified by '新密码';
ALTER user 'root'&#