1、下载地址:https://dev.mysql.com/downloads/mysql/5.7.html#downloads
请自行下载对应版本,这里以64位为例
2、解压
tar -xvf mysql-5.7.40-linux-glibc2.12-x86_64.tar.gz
3、移动并重命名
mv mysql-5.7.40-linux-glibc2.12-x86_64 /usr/local/mysql
4、配置my.cnf
vim /etc/my.cnf
5、改为一下内容
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/data/mysql.err
pid-file=/usr/local/mysql/data/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
6、初始化
cd /usr/local/mysql/bin/
/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=root --initialize
7、查看密码,这个密码复制一下,后面需要使用
cat /usr/local/mysql/data/mysql.err
8、启动并查看启动状态
service mysql start
ps -ef|grep mysql
9、登录,密码为步骤7中查看的密码
./mysql -u root -p #/usr/local/mysql/bin目录下
10、重设密码,并刷新
SET PASSWORD = PASSWORD('123');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
11、测试工具
12、MySQL设置开启动服务
chkconfig --add mysql
chkconfig --list
13、开机启动
chkconfig --level 345 mysql on
14、注意:如果测试工具连接失败,请关闭防火墙再次尝试