下载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

标签: Database, MySQL

添加新评论