linux安装包安装mysql5.7

1、下载

https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2、本地环境配置

yum install libaio
groupadd mysql
useradd -r -g mysql mysql

3、解压移动

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

4、创建配置文件

[root@localhost mysql]# pwd
/usr/local/mysql
[root@localhost mysql]# touch my.cnf 

 5、编辑配置，注意basedir、datadir、log_bin这三个路径要跟实际匹配

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

#个人需要，开启binlog
server_id              = 66
binlog_format          = ROW
log_bin                = /data/binlog
gtid-mode              = on
enforce-gtid-consistency           = 1      # 设置为主从强一致性
log-slave-updates                  = 1      # 记录日志

6、初始化数据库

注意my.cnf配置文件的级别最好644，如果是777mysql会因为级别太高而自动忽略配置。

[root@localhost mysql]# pwd
/usr/local/mysql
[root@localhost mysql]# ./bin/mysqld --defaults-file=my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize

需要注意修改配置文件需要重新初始化，非首次初始化会报错，先删除数据文件：

[ERROR] --initialize specified but the data directory has files in it. Abort

[错误] -初始化指定，但数据目录中有文件。中止

解决方法：将数据目录下已存在的文件全部删除。如：rm -rf /data/mysql/*

rm -rf /data/mysql/*

 7、查看密码

cat /data/mysql/mysql.err

 8、启动mysql，并更改密码，开放远程

#启动
./support-files/mysql.server start

#进入
./bin/mysql -u root -p  

#修改密码
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;                                 

#开放远程登录权限
use mysql                                            
update user set host = '%' where user = 'root';      
FLUSH PRIVILEGES;