一、准备

1、官网下载MySQL安装包：https://dev.mysql.com/downloads/mysql/
2、创建mysql用户组，用户

#进入目录
cd /usr/local/
#创建mysql文件夹
mkdir mysql
#创建data文件架
cd mysql
mkdir data

3、创建用户和用户组

#创建用户组
groupadd mysql
#创建用户
useradd -g mysql -d /usr/local/mysql mysql

二、解压缩

1、解压

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

image.png

2、将解压完的文件移动到/usr/local/mysql中

cd mysql-5.7.30-linux-glibc2.12-x86_64
mv * /usr/local/mysql/

三、安装配置

1、初始化数据库

./bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize

执行该命令可能会报错：

./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

如果报错就执行下面这行：

yum install -y libaio

重新执行初始化命令完成安装

image.png

2、修改配置文件和启动文件的mysql路径

• 修改my.cnf文件如下,vi /etc/my.cnf

[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
port=3306
max_connections = 10000
log-bin=mysql_bin
lower_case_table_names=1
server-id=31
user=mysql
character-set-server= utf8
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
default-character-set=utf8
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

• 修改msyql.server文件如下 vi /usr/local/mysql/support-files/msyql.server

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

3、测试是否启动成功

image.png

4、启动成功后先暂时停止

image.png
5、创建软链接

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

6、修改mysql登录密码
  修改密码时需要在“Enter password”输入默认密码

image.png

7、给mysql授权

GRANT all privileges ON *.*  TO 'root'@'%' identified by '123456'
flush privileges;

完成

参考：
安装：https://www.jianshu.com/p/2b63edab7f44
修改初始密码：https://blog.csdn.net/zhangyu4863/article/details/82188555
忘记密码：https://blog.csdn.net/lzb348110175/article/details/103055606