- 下载rpm-bundle.tar
https://dev.mysql.com/downloads/mysql/
- 将安装包上传至目标机器
- 检查是否安装了mariadb
在安装mysql之前要先检查下是否已经安装了mariadb,如果安装了,需要先将其卸载。因为centos7系统默认使用的数据库是mariadb,会与mysql产生冲突。
[root@hadoop03 wyh]# rpm -qa|grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
查出来说明机器上已经有了mariadb,所以我们强制要卸载mariadb:
[root@hadoop03 wyh]# rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps
再次验证是否还有mariadb:
[root@hadoop03 wyh]# rpm -qa|grep mariadb
- 解压安装包
[root@hadoop03 wyh]# tar -xvf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
- 安装mysql所依赖的包
[root@hadoop03 wyh]# rpm -ivh mysql-community-common-5.7.37-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-5.7.37-1.e################################# [100%]
[root@hadoop03 wyh]# rpm -ivh mysql-community-libs-5.7.37-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-libs-5.7.37-1.el7################################# [100%]
[root@hadoop03 wyh]# rpm -ivh mysql-community-client-5.7.37-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-client-5.7.37-1.e################################# [100%]
[root@hadoop03 wyh]# yum install -y net-tools
[root@hadoop03 wyh]# yum install -y perl
[root@hadoop03 wyh]# yum install -y libaio
- 安装mysql
[root@hadoop03 wyh]# rpm -ivh mysql-community-server-5.7.37-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-server-5.7.37-1.e################################# [100%]
- 开启mysql服务
[root@hadoop03 wyh]# systemctl start mysqld
- 查看mysql服务状态
[root@hadoop03 wyh]# systemctl status mysqld
- 登陆mysql
在第一启动mysql服务时,会自动生成一个随机密码,可以在/var/log/mysqld.log中查看:
所以我们第一次登陆mysql时使用这个临时的随机密码:
[root@hadoop03 log]# mysql -u root -p
- 修改密码设置规则
由于我是用来测试学习的,所以会将密码设置得比较简单,这样就需要先去修改密码的校验规则:
mysql> set global validate_password_policy=LOW;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=4;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_mixed_case_count=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_number_count=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_special_char_count=0;
Query OK, 0 rows affected (0.00 sec)
- 修改密码
mysql> alter user root@localhost identified by '123456';
- 授权其他机器可以远程登陆该节点的mysql
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
- 验证服务是否正常
这里就简单地试一下sql能否正常执行。
mysql> show databases;
以上就是使用rpm-bundle包来安装mysql的过程。