Centos安装mysql 并开启远程登录

1. 使用tar命令解压(安装包链接 提取码：4wl5)

tar -xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar

2. 安装新版mysql前，需将系统自带的mariadb-lib卸载
先用如下命令查看

rpm -qa|grep mariadb

比如查看出来的名字为(mariadb-libs-5.5.52-1.el7.x86_64)
则用如下命令删除

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

3. 严格按照如下顺序安装

rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm

4. vim /etc/my.cnf 底部添加如下三行

skip-grant-tables
character_set_server=utf8
init_connect='SET NAMES utf8'

[skip-grant-tables：跳过登录验证
character_set_server=utf8：设置默认字符集UTF-8
init_connect=‘SET NAMES utf8’：设置默认字符集UTF-8]
5. 设置开机启动

systemctl start mysqld.service

6. 启动mysql

mysql

7. 先设置一个简单的密码并立即生效

update mysql.user set authentication_string=password('123456') where user='root';
flush privileges;

8. 退出mysql并停止mysql服务

exit
systemctl stop  mysqld.service

9. 编辑my.cnf配置文件将：skip-grant-tables这一行注释掉
10. 重启mysql服务并再次登录mysql

systemctl start mysqld.service
mysql -u root -p 123456 

11. .更新密码

alter user user() identified by "Jsict@99999";

12. 开启远程登录

grant all privileges on *.* to 'root'@'%' identified by 'Jsict@99999' with grant option;