使用 rpm 方式安装
须要的 mysql组件,有4个:分别是server、client、common、libs
解压
[root@mysql01 src]# tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm
mysql-community-libs-5.7.26-1.el7.x86_64.rpm
mysql-community-embedded-5.7.26-1.el7.x86_64.rpm
mysql-community-test-5.7.26-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm
mysql-community-common-5.7.26-1.el7.x86_64.rpm
mysql-community-devel-5.7.26-1.el7.x86_64.rpm
mysql-community-client-5.7.26-1.el7.x86_64.rpm
mysql-community-server-5.7.26-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm
查看是否存在旧的mysql
[root@mysql01 src]# rpm -qa|grep mysql
[root@mysql01 src]# rpm -qa|grep mariadb
[root@mysql01 ~]# rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
安装
安装顺序 common→libs→client→server
[root@mysql01 src]# yum -y install net-tools perl perl-devel
[root@mysql01 src]# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
[root@mysql01 src]# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
[root@mysql01 src]# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
[root@mysql01 src]# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
启动/停止mysql
[root@mysql01 src]# systemctl start mysqld
[root@mysql01 src]# systemctl status mysqld
[root@mysql01 src]# systemctl stop mysqld
查找初始化密码
[root@mysql01 src]# cat /var/log/mysqld.log |grep password
2020-02-18T02:11:16.594216Z 1 [Note] A temporary password is generated for root@localhost: sa1%wU#S8E1#
修改mysql登录密码
为了测试方便先禁用密码复杂性验证插件
[root@mysql01 src]# vi /etc/my.cnf
validate_password=off
[root@mysql01 src]# systemctl restart mysqld
[root@mysql01 src]# systemctl status mysqld
[root@mysql01 src]# mysql -uroot -psa1%wU#S8E1#
mysql> set password for root@localhost=password('000000');
测试远程访问/连接
[root@mysql01 src]# mysql -uroot -p000000 -h192.168.17.131
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1130 (HY000): Host '192.168.17.131' is not allowed to connect to this MySQL server # 表示不能远程登录
开启远程登录/连接
mysql> grant all privileges on *.* to 'root'@'%' identified by '000000';
mysql> flush privileges;
mysql> use mysql;
mysql> select host,user from user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | root |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+