1.window系统

报错后解决视频：

Linux系统下载：

1.检查是否已安装 

rpm -qa|grep -i mysql
# 若安装了，需要卸载
rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps

2.官网下载 MySQL 包

rpm -qa|grep glibc

官网：https://downloads.mysql.com/archives/community/

3.上传解压至home目录，将压缩包移动到usr/local目录下

tar -xJvf mysql-8.4.2-linux-glibc2.17-x86_64.tar.xz
mv /home/mysql-8.4.2-linux-glibc2.17-x86_64  /usr/local/mysql8.4.2

4.创建用户组

groupadd mysql #创建用户组
useradd -r -g mysql mysql
chown -R mysql /usr/local/mysql8.4.2/
chgrp -R mysql /usr/local/mysql8.4.2/

5.创建数据目录并赋予权限

mkdir -p /data/mysql #数据目录
chown -R mysql:mysql /data/mysql
chmod -R 755 /data/mysql

6.修改配置文件

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql8.4.2
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
lower_case_table_names=1
[client]
default-character-set=utf8mb4
socket=/tmp/mysql.sock
[mysql]
default-character-set=utf8mb4
socket=/tmp/mysql.sock

7.初始化数据库

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

cat /data/mysql/mysql.err

8.创建MySQL服务

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

chkconfig --add mysqld

chkconfig --list mysqld

service mysql start

service mysql status

9.配置全局环境变量

export PATH=$PATH:/usr/local/mysql8.4.2/bin:/usr/local/mysql8.4.2/lib

source /etc/profile

10.登录MySQL修改密码

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxx';# 修改密码

use mysql;
# 最后授权 MySQL，允许远程用户登录访问 MySQL 授权远程用户连接
update user set host = '%' where user = 'root';

flush privileges;

systemctl status firewalld
# 永久开放端口
firewall-cmd --list-ports --permanent

firewall-cmd --zone=public --add-port=3306/tcp --permanent 

firewall-cmd --reload

sudo ufw allow 3306

#新建用户
CREATE USER 'test_user'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'test_user'@'%';
FLUSH PRIVILEGES;

CREATE USER 'readonly'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON *.* TO 'readonly'@'%';
FLUSH PRIVILEGES;

GRANT SELECT, SHOW VIEW ON your_database.* TO 'tys_user'@'%';
GRANT ALL PRIVILEGES ON data_gateway.* TO 'tys_user'@'%';
FLUSH PRIVILEGES;

取消授权
REVOKE ALL PRIVILEGES ON *.* FROM 'tys_user'@'%';