Mysql服务rpm包离线安装

1.首先检查是否安装过mysql
[root@bogon mysql]# rpm -qa|grep mysql
[root@bogon mysql]# rpm -qa|grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64

2.如有安装mariadb，则卸载
[root@bogon mysql]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

3.下载mysql-5.7.36-1.el7.x86_64.rpm-bundler.tar安装包到/opt/目录下,创建mysql5.7目录，并解压
[root@bogon ~]# cd /opt
[root@bogon opt]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar
[root@bogon opt]# mkdir mysql5.7
[root@bogon opt]# tar -xvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar -C /opt/mysql5.7/
[root@bogon opt]# cd mysql5.7
[root@bogon mysql5.7]# ll
总用量 533076
-rw-r–r–. 1 7155 31415 26664808 9月 8 2021 mysql-community-client-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 317808 9月 8 2021 mysql-community-common-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 4118740 9月 8 2021 mysql-community-devel-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 47760636 9月 8 2021 mysql-community-embedded-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 23316608 9月 8 2021 mysql-community-embedded-compat-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 132191192 9月 8 2021 mysql-community-embedded-devel-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 2473272 9月 8 2021 mysql-community-libs-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 1263988 9月 8 2021 mysql-community-libs-compat-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 182267476 9月 8 2021 mysql-community-server-5.7.36-1.el7.x86_64.rpm
-rw-r–r–. 1 7155 31415 125479900 9月 8 2021 mysql-community-test-5.7.36-1.el7.x86_64.rpm

4.一次性安装上传rpm包，如出现下面错误，则安装perl
[root@bogon mysql5.7]# rpm -ivh --force --nodeps *.rpm

[root@bogon mysql5.7]# systemctl start mysqld
[root@bogon mysql5.7]# grep password /var/log/mysqld.log
2023-03-01T03:22:32.919615Z 1 [Note] A temporary password is generated for root@localhost: qaw.d0N_%(je

5.修改初始化密码
[root@bogon mysql5.7]# mysql -uroot -p
Enter password: qaw.d0N_%(je
mysql> set password=password(‘Abc123!@#’);
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> show variables like ‘validate_password%’;
±-------------------------------------±-------+
| Variable_name | Value |
±-------------------------------------±-------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 8 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | MEDIUM |
| validate_password_special_char_count | 1 |
±-------------------------------------±-------+
7 rows in set (0.01 sec)

6.开启允许远程连接数据库
#重新设置密码
mysql> set password=password(‘root’);
Query OK, 0 rows affected, 1 warning (0.00 sec)
#开启远程连接数据库
mysql> grant all privileges on . to root@‘%’ identified by ‘root’ with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
在其他电脑使用Navicat连接工具测试，连接成功

7.设置编码字符集,修改/etc/my.cnf文件设置字符集
[root@bogon mysql5.7]# vi /etc/my.cnf
#添加如下编码配置
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

8.重启mysql，并登录mysql查看字符集
[root@bogon mysql5.7]# systemctl restart mysqld
[root@bogon mysql5.7]# mysql -uroot -p
Enter password: root
mysql> show variables like ‘%character%’;
±-------------------------±---------------------------+
| Variable_name | Value |
±-------------------------±---------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
±-------------------------±---------------------------+