MySQL-Linux(CentOS 7)安装

112 阅读1分钟

1.

wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2.

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

3.

cd /etc/yum.repos.d
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-server

4.

systemctl start mysqld

5. 获取默认登录密码

grep 'A temporary password' /var/log/mysqld.log

image.png

6. 登录

mysql -u root -p

回车,提示输入密码,输入刚才的默认密码,回车。

image.png

7. 重新设置登录密码(可选操作)

set global validate_password_policy=LOW;
set global validate_password_length=6;
ALTER USER USER() IDENTIFIED BY '123456';

8. 配置远程登录权限

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

可参考:【超详细】CentOS 7安装MySQL 5.7【安装及密码配置、字符集配置、远程连接配置】_mysql contos 密码配置文件-CSDN博客