刚刚！MySQL8.4.0 LTS发布，接着再探

📣 前言

📣 1.MySQL8版本变更

📣 2.MySQ 8.4.0变更

📣 3.MySQ 8.4.0 新版体验

✨ 3.1 安装包下载

✨ 3.2 安装依赖

✨ 3.3 添加用户及组

✨ 3.4 安装包上传解压

✨ 3.5 正式安装

✨ 3.6 初始化

📣 4.启动 MySQL 服务

4.1 授权启动

4.2 登陆新增用户

## 临时密码登陆
grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p

## 修改本地用户密码
mysql> alter user root@'localhost' identified with mysql_native_password by 'root';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select Host,User from mysql.user;
+-----------+------------------+
| Host      | User             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

##新增远程登陆
mysql> create user root@'%' identified with mysql_native_password by 'root';
mysql> grant all on *.* to root@'%' with grant option;
mysql> flush privileges;

📣 5.升级说明

📣 6.总结