Linux安装mysql-5.7.38

yum install wget

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

#解压
tar -zxvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
#将mysql-5.7.38-linux-glibc2.12-x86_64重命名为mysql
mv mysql-5.7.38-linux-glibc2.12-x86_64 mysq

groupadd mysql
useradd -r -g mysql mysql

#创建数据库目录
mkdir -p  /data/mysql
#赋予数据库目录权限
chown mysql:mysql -R /data/mysql

vim /etc/my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]
user=mysql
port = 33306
sql-mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
character_set_server=utf8mb4
init_connect='SET NAMES utf8'
explicit_defaults_for_timestamp=true
lower_case_table_names = 1
#
# 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
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid

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

root@localhost: PASSWORD

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

#启动mysql
service mysql start
#查看mysql运行状态
service mysql status
ps -ef|grep mysql

#由于当前并没有全局设置mysql命令，所以先切换到/usr/local/mysql/bin/文件夹下
./mysql -uroot -pPASSWORD

SET PASSWORD = PASSWORD('newPassword');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;       
use mysql;
#使root用户可以在任何IP访问
update user set host = '%' where user = 'root';
#刷新
FLUSH PRIVILEGES;

ln -s /usr/local/mysql/bin/mysql /usr/bin/

#设置mysql开机自启动
chkconfig mysql on
#取消mysql开机自启动
chkconfig mysql off
# 查看系统服务列表，以及每个服务的运行级别
chkconfig --list
#或
 systemctl list-unit-file