centos mysql安装配置远程访问

女爷i 2024-03-16 19:22 48阅读 0赞

包含以下三个部分：mysql安装，mysql密码重置、mysql配置远程访问。

### 一 centos安装mysql ###

1、wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

![aa91447fdce145bba2fc6e361099629b.png][]

2、yum -y install mysql57-community-release-el7-10.noarch.rpm

![003be3e600e24e58b0f95ccc19ac3efe.png][]

3、yum -y install mysql-community-server

安装过程如果出现以下错误，可以调用

> `Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Importing GPG key 0x5072E1F5: Userid : "MySQL Release Engineering " Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5 Package : mysql57-community-release-el7-10.noarch (@/mysql57-community-release-el7-10.noarch) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Public key for mysql-community-common-5.7.42-1.el7.x86_64.rpm is not installed Failing package is: mysql-community-common-5.7.42-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql`

**rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022**

然后调用yum -y install mysql-community-server重新安装。

4、systemctl start mysqld.service

调用成功后可以使用service mysqld status 查看mysql的状态

转存失败重新上传取消

### 二 密码重置 ###

1、grep "password" /var/log/mysqld.log (备注：查看默认临时密码)  
![690cd65d0b9642db945f3233ac1d5c12.png][]

2、mysql -uroot -p （备注：输入刚刚默认的密码）

3、set global validate\_password\_policy=0;

4、set global validate\_password\_length=5;

5、ALTER USER 'root'@'localhost' IDENTIFIED BY '你的新密码' ;

6、 SHOW VARIABLES LIKE 'validate\_password%';

![2d0fa8cef97d48d0b9518f9c0d8acc3b.png][]

### 三 配置远程访问 ###

1、查看数据库

show databases;

![ae0bbcbe3da745ee84340022f1823b2a.png][]

`切换到系统数据库mysql：use mysql;`

`查看user的认证信息：Select Host, User, authentication_string from user;`

![154e786018f04f5e9f02734db1925328.png][]

授权远程访问：

grant all privileges on *.* to root@'%'identified by '输入你自己的mysql密码';

![191f2b37fb464a70a535b7f911a05790.png][]

[aa91447fdce145bba2fc6e361099629b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/cb7c4a6045414832bfadec4229c13f64.png
[003be3e600e24e58b0f95ccc19ac3efe.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/475008629b124f53ae1c11d8374e2687.png
[690cd65d0b9642db945f3233ac1d5c12.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/af0aab5be6c347bdbc88e086b3c0188e.png
[2d0fa8cef97d48d0b9518f9c0d8acc3b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/befeca4903184d5fa952cbc32e42cd3d.png
[ae0bbcbe3da745ee84340022f1823b2a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/600d8bcf1b1b43a687ac6a857d319d20.png
[154e786018f04f5e9f02734db1925328.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/4fd656c2865c41c4bf5309c14620e9b1.png
[191f2b37fb464a70a535b7f911a05790.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/3160864e2aee4052b5e5343e26fae7f6.png