Linux 安装 Mysql5.7

创建数据目录并赋予权限

groupadd mysql
useradd -r -g mysql mysql

创建目录、赋予权限：
mkdir -p  /data/mysql              
chown mysql:mysql -R /data/mysql

下载-解压-配置-安装（/usr/local）

下载地址：https://dev.mysql.com/downloads/mysql/5.7.html#downloads
下载之后通过ftp拉进服务器

tar -xvf mysql-5.7.26-linux-glibc2.12-x86_64.tar 
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql

配置my.cnf

vim /etc/my.cnf

# 复制一下内容粘贴
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
plugin-load-add=validate_password.so
validate-password=FORCE_PLUS_PERMANENT

初始化数据库

进入MySQL的bin目录

cd /usr/local/mysql/bin/

./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ -user=mysql --initialize

查看初始密码

cat /data/mysql/mysql.err

启动MySQL并修改初始密码

#启动数据库
cd /usr/local/mysql/support-files/

./mysql.server start

#进入数据库
cd /usr/local/mysql/bin

./mysql -uroot -p
#输入刚刚的初始密码

set global validate_password_policy=0;
set global validate_password_length=1;
alter user 'root'@'localhost' identified by 'root';

#设置可以远程登录
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES; //刷新

设置开机自动启动

vim /lib/systemd/system/mysqld.service

#复制以下内容粘贴
[Unit]
Description=MySQL Server
After=network.service
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
TimeoutSec=0
PermissionsStartOnly=true
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --daemonize
LimitNOFILE=5000
Restart=on-failure
RestartSec=10
RestartPreventExitStatus=1
PrivateTmp=false

配置开机自启动

systemctl daemon-reload
systemctl enable mysqld