CentOS7安装Mysql并配置远程登录

在CentOS7上安装mysql57

准备工作

• 卸载CentOS7中默认安装的MariaDB
  1.查询MariaDB软件包

rpm -qa | grep -i mariadb

[root@localhost ~]# rpm -qa | grep -i mariadb
mariadb-libs-5.5.68-1.el7.x86_64

2.卸载MariaDB

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

3.检查mysql是否卸载干净

rpm -qa | grep mysql

下载mysql57

• 下载mysql rpm包

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

• 安装rpm包

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

	默认安装mysql57，如果需要更改版本修改/etc/yum.repos.d/mysql-community.repo文件的enabled属性

• 更新GPG密钥

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

• 安装mysql

yum -y install mysql-community-server

运行mysql服务配置登录

• 启动mysql服务

systemctl start mysqld

• 查看mysql默认密码

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

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
2023-03-06T11:46:29.659583Z 1 [Note] A temporary password is generated for root@localhost: k6l6e:pNobdt

	这里知道mysql的默认密码是k6l6e:pNobdt进行登录

• 登录mysql

mysql -u root -p

修改密码及允许远程登录

• 修改密码

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

	mysql57安全策略，密码要求大小写字母数字特殊符号至少8位

• 允许远程登录

    修改mysql库中的user表的数据，将root用户的host改为%
  

mysql> use mysql;
Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

• 刷新权限

flush privileges;