linux安装mysql 5.7.31实战

1.下载地址

https://dev.mysql.com/downloads/mysql/

2.下载tar.gz包

选择redhat版本

3.安装

1.linux系统上创建mysql用户

useradd mysql

2.将tar.gz包上传到服务器上并且解压

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

3.将mysql-5.7.31-el7-x86_64目录下的文件mv到 /home/mysql下

4.mkdir -p /home/mysql/data 文件存储mysql数据目录

mkdir -p /home/mysql/data

5.对/home/mysql下赋权

chmod -R 755 /home/mysql
chown mysql:mysql -R /home/mysql/data
chmod 777 /home/mysql/data

6.修改mysql配置文件

vi /etc/my.cnf

# 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

#bind-address=127.0.0.1
port=3306
user=mysql
basedir=/home/mysql
datadir=/home/mysql/data
socket=/home/mysql/mysql.sock
#socket=/data/mysql/mysql.sock
log-error=/home/mysql/mysql.err
pid-file=/home/mysql/mysql.pid
##character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

[mysqld_safe]
#log-error=/var/log/mariadb/mariadb.log
#log-error=/data/mysql/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid
#pid-file=/data/mysql/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

7.初始化mysql

./mysqld --initialize --user=mysql --datadir=/home/mysql/data --basedir=/home/mysql

8.启动mysql

/home/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/home/mysql --datadir=/home/mysql/data --plugin-dir=/home/mysql/lib/mysql/plugin --log-error=/home/mysql/mysqld.log --pid-file=/home/mysql/mysqld.pid --socket=/home/mysql/mysql.sock --port=3306

9.使用root登录mysql

查看初始化默认密码 cat /data/mysql/mysql.err
./mysql -u root -p -S/home/mysql/mysql.sock 输入初始化的密码
SET PASSWORD = PASSWORD('paaswdhejw777');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
或执行命令：set password for root@localhost = password('paaswdhejw777');
FLUSH PRIVILEGES;

10.登录mysql