Linux中 rpm 安装 MySQL

1，下载rpm包 wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.40-1.el7.x86_64.rpm-bundle.tar

 2，解包 tar -xvf mysql-5.7.40-1.el7.x86_64.rpm-bundle.tar

 

【如果centos7 中有mariadb数据库。需要卸载

[root@localhost ~]# rpm -qa | fgrep mariadb

mariadb-libs-5.5.68-1.el7.x86_64

[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

[root@localhost ~]# rpm -qa | fgrep mariadb

】

3，安装 MySQL

rpm -ivh mysql-community-common-5.7.40-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.40-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.40-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.40-1.el7.x86_64.rpm

 

4，启动服务 systemctl start mysqld

5，修改初始密码

cd /var/log/

① 找到原密码

grep -F password /var/log/mysqld.log 【找到复制原密码】

②进入数据库：

mysql -uroot -p 【输入原密码】

  ③设置密码 set password = password("新密码");

  ④刷新权限 flush privileges;

 

6，设置用户可以远程登录

grant all PRIVILEGES on . to 'root'@'%' IDENTIFIED BY '新密码' with grant option;

flush privileges; 刷新权限

exit; 退出数据库

 7, 验证是否成功： navicat 中新建MySQL数据库，连接成功