Ubuntu20.04安装mysql8

查了资料，有两种安装方式。一种是官网下deb包install ；另一种是用apt安装，apt能默认安装最新版，所以我用apt安装。
#更新源
1、sudo apt-get update
#安装mysql服务
2、sudo apt-get install mysql-server
#初始化配置，可以配置密码等
3、sudo mysql_secure_installation
#检查mysql服务状态，如下则启动成功
4、systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>
Active: active (running) since Sun 2021-07-04 17:43:14 CST; 1h 44min ago
Main PID: 595057 (mysqld)
Status: “Server is operational”
Tasks: 39 (limit: 14171)
Memory: 348.2M
CGroup: /system.slice/mysql.service
└─595057 /usr/sbin/mysqld

7月 04 17:43:12 xuelongzhang-K56CM systemd[1]: Starting MySQL Community Server.>
7月 04 17:43:14 xuelongzhang-K56CM systemd[1]: Started MySQL Community Server.
5、如果用navicat或者其他连接工具连接报错，是因为mysql8更改了root用户的授权方式，通过Unix socket验证所有连接到localhost的用户，不能通过密码直连。通过下面指令来更新一下授权方式。
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password by ‘root的密码’;

参考文献：
https://blog.csdn.net/weixin_38924500/article/details/106261971
https://blog.csdn.net/cruiserblog/article/details/106934570
https://blog.csdn.net/weixx3/article/details/80782479