01-mysql主从安装

使用 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          |
+-----------+---------------+