通过RPM包安装MySQL5.7
下载MySQL的RPM包
下载地址:https://dev.mysql.com/downloads/mysql/
操作系统选择Red Hat Enterprise Linux,下载示例mysql-5.7.31-1.el7.x86_64.rpm-bundle.tar。
也可以单独下载以下4个RPM包。
mysql-community-common-5.7.31-1.el7.x86_64.rpm
mysql-community-libs-5.7.31-1.el7.x86_64.rpm
mysql-community-client-5.7.31-1.el7.x86_64.rpm
mysql-community-server-5.7.31-1.el7.x86_64.rpm
通过rpm命令安装
rpm -ivh mysql-community-common-5.7.31-1.el7.x86_64.rpm mysql-community-libs-5.7.31-1.el7.x86_64.rpm mysql-community-client-5.7.31-1.el7.x86_64.rpm mysql-community-server-5.7.31-1.el7.x86_64.rpm
#需要按此顺序安装,前一个是后一个的依赖。启动MySQL服务
systemctl start mysqld
#启动MySQL服务
grep password /var/log/mysqld.log
#查看日志中的root用户密码。
mysql -u root -p
#root用户登陆
SET PASSWORD = PASSWORD("新密码");
#修改root用户密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
#允许用户远程连接数据库默认目录
默认数据文件目录
/var/lib/mysql