linux离线安装mysql5.7

准备工作

下载安装包：mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

选定目录

安装目录：/usr/local，将安装包上传至/usr/local目录下，通过ftp方式传输

具体步骤

cd /usr/local

解压

tar -zxvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

重命名

mv mysql-5.7.38-linux-glibc2.12-x86_64 mysql

检查系统是否自带mariadb并卸载

rpm -qa | grep mariadb

rpm -e --nodes 'npm包名'

删除/etc下的my.cnf（有就删除），我这里没有，略过

创建用户名和组

groupadd mysql

useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql

给mysql文件目录更改权限

cd /usr/local

chown -R mysql:mysql mysql/

在mysql文件夹下创建data目录，并修改用户组和用户

cd /usr/local/mysql

mkdir data

chown -R mysql:mysql data

在/etc下创建my.conf文件

vim /etc/my.conf

[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=256M
character_set_server=utf8mb4
innodb_default_row_format=DYNAMIC
innodb_large_prefix=ON
innodb_file_format=Barracuda
transaction-isolation=READ-COMMITTED
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid
#不区分大小写
lower_case_table_names = 1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=5000

修改配置文件组和用户

cd /etc

chown -R mysql:mysql my.conf

chmod 777 my.conf

进入mysql文件夹，安装mysql

cd /usr/local/mysql

bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

cp ./support-files/mysql.server /etc/init.d/mysqld

chmod a+x /etc/init.d/mysqld

注意：如果修改数据目录需要修改/etc/init.d/mysqld中的datadir字段

配置环境变量

vim /etc/profile

export PATH=$PATH:/usr/local/mysql/bin

刷新环境变量

source /etc/profile

启动mysql

service mysqld start

service mysqld status

登录mysql并设置基础环境

cat /root/.mysql_secret

mysql -u root -p

set PASSWORD=PASSWORD('123456');

flush privileges;

设置root远程登录用户

grant all on *.* to root@'%' identified by '123456';

flush privileges;

use mysql;

select user, host from user;

delete from user where user='root' and host='localhost';

flush privileges;

重启mysql

service mysqld restart