基础架构系列篇-系统centos7中安装mysql8.0.23(已更新)

1. 下载MYSQL8

地址: https://dev.mysql.com/downloads/mysql/
查看系统版本

选择MYSQL8版本

2. 上传到服务器

以root用户登录服务器
执行以下指令
mkdir -p /data1/mysql8
使用FTP工具将下载的压缩包传至/data1/mysql8目录

3. 安装

执行
cd /data1/mysql8

查看删除已安装版本mysql
rpm -qa | grep
rpm -qa | grep mariadb
rpm -e 应用rpm包 --nodeps

解压
tar -xzvf mysql-8.0.23-el7-x86_64.tar.gz

添加用户
groupadd mysql8
useradd -g mysql8 mysql8
chown -R mysql8.mysql8 mysql-8.0.23-el7-x86_64

cd mysql-8.0.23-el7-x86_64
(读文件.cnf顺序 /etc/ -> basedir/ -> datadir -> ~/)
vim my.cnf
输入
[client]
port=3306
default-character-set=utf8mb4

[mysqld]
user=mysql8
server-id=1
port=3306
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
default-authentication-plugin=mysql_native_password
default-storage-engine=INNODB
max_connections=2000
basedir=/data1/mysql8/mysql-8.0.23-el7-x86_64
datadir=/data1/mysql8/mysql-8.0.23-el7-x86_64/data
pid-file=/data1/mysql8/mysql-8.0.23-el7-x86_64/mysql8.pid
log_error=/data1/mysql8/mysql-8.0.23-el7-x86_64/mysql8-error.log
slow_query_log_file=/data1/mysql8/mysql-8.0.23-el7-x86_64/mysql8-slow.log
lower-case-table-names=1

执行 ./bin/mysqld --user=mysql8 --basedir=/data1/mysql8/mysql-8.0.23-el7-x86_64
–datadir=/data1/mysql8/mysql-8.0.23-el7-x86_64/data --initialize --lower-case-table-names=1
记录屏幕打印的密码
[Server] A temporary password is generated for root@localhost: EkerjS9Eaq?C

启动
./support-files/mysql.server start
异常
修改mysql.server参数
basedir=/data1/mysql8/mysql-8.0.23-el7-x86_64
datadir=/data1/mysql8/mysql-8.0.23-el7-x86_64/data

按提示
执行 vim mysql8-error.log :wq
执行 mkdir tmp
启动./support-files/mysql.server start

执行 ./support-files/mysql.server restart
登录 ./bin/mysql -uroot -p
修改
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘密码’;
flush privileges;
验证
show databases;
exit;

4. 开机启动

cd /data1/mysql8/mysql-8.0.23-el7-x86_64/
添加服务cp -a ./support-files/mysql.server /etc/init.d/mysql8
chmod +x /etc/init.d/mysql8
chkconfig --add mysql8

service mysql8 start
service mysql8 status
service mysql8 restart
service mysql8 stop

5. 设置外网连接与使用NAVICAT PREMIUM12工具连接MYSQL8

登录 ./bin/mysql -uroot -p
use mysql;
update user set host=’%’ where user=‘root’;
flush privileges;

连接异常
https://blog.csdn.net/pan_zzq/article/details/81078564

6. 云服务器打开mysql8访问端口连接