Centos 8 安装MySQL 5.7

1.下载

mysql下载地址：https://downloads.mysql.com/archives/community/

找到对应的系统版本以及需要的mysql版本下载

或者直接

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

2.解压

tar xzf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.7.33-linux-glibc2.12-x86_64 /usr/local/mysql

3.创建用户

groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql mysql

4.配置Mysql

4.1 配置数据存储目录

mkdir -p /www/data/mysql
chown -R mysql:mysql /www/data/mysql

4.1 配置my.cnf

vi /etc/my.cnf

插入内容

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/www/data/mysql
socket=/tmp/mysql.sock
log-error=/www/data/mysql/mysql.err
pid-file=/www/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

4.4 初始化数据库

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

然后在/www/data/mysql/mysql.err找到数据库初始密码

5.启动

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

service mysqld restart

6. 修改密码

先使用初始密码登陆

/usr/local/mysql/bin/mysql -u root -p

修改密码

alter user 'root'@'localhost' identified by 'dffdfd';

flush privileges;