【Linux】 CentOS 7.5 离线环境安装MySQL5.7.30

1、外网环境下载安装包

http://dev.mysql.com/get/mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar

2、拷贝到内网环境并解压

tar -xvf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar

3、查看系统里是否已经有安装过mysql，有则卸载

rpm -qa|grep mariadb 【查看】

rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64【卸载】

4、安装mysql5.7所需要的依赖

yum install libaio
yum install perl
yum install net-tools

5、安装mysql

rpm -ivh mysql-community-common-5.7.30-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-libs-5.7.30-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-libs-compat-5.7.30-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-client-5.7.30-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-server-5.7.30-1.el7.x86_64.rpm --force --nodeps

6、配置mysql数据库

启动mysql

systemctl start mysqld.service

查看mysql运行状态

systemctl status mysqld.service

7、修改root密码

mysql -p -uroot
密码为空
SET PASSWORD FOR root@localhost = PASSWORD('123456');
flush privileges;

开启mysql的远程访问【下面命令开启的IP是 192.168.0.1，如要开启所有的，用%代替IP】

grant all privileges on . to 'root'@'192.168.0.1' identified by 'password' with grant option;
flush privileges;
exit

8、为firewalld添加开放端口【添加mysql端口3306和Tomcat端口8080】

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --add-port=8080/tcp --permanent
或者选择吧firewalld服务临时关闭【service firewalld stop】

9、修改字符集

【重新登录mysql，然后输入status，经过观察，不难发现里面有两个不是utf-8】

改为utf-8方法：

vi /etc/my.cnf

新增下列四行
[client]
default-character-set=utf8

character-set-server=utf8
collation-server=utf8_general_ci
实现的效果如下所示：
​```
[client]
default-character-set=utf8
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
 
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8
collation-server=utf8_general_ci
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
​```

10、重启mysqld 服务

systemctel restart mysqld

11、其他

mysql_upgrade -u root -p 回车
输入mysql密码