Ubuntu20.04安装Mysql8.0.29详细步骤

一、Mysql
1、首先更改镜像源文件
/etc/apt/source.list
替换为下面文件
deb https://mirrors.aliyun.com/ubuntu/ trusty main restricted universe multiverse
deb-src https://mirrors.aliyun.com/ubuntu/ trusty main restricted universe multiverse
deb https://mirrors.aliyun.com/ubuntu/ trusty-security main restricted universe multiverse
deb-src https://mirrors.aliyun.com/ubuntu/ trusty-security main restricted universe multiverse
deb https://mirrors.aliyun.com/ubuntu/ trusty-updates main restricted universe multiverse
deb-src https://mirrors.aliyun.com/ubuntu/ trusty-updates main restricted universe multiverse
deb https://mirrors.aliyun.com/ubuntu/ trusty-backports main restricted universe multiverse
deb-src https://mirrors.aliyun.com/ubuntu/ trusty-backports main restricted universe multiverse

2、执行更新
sudo apt-get update
#更新源镜像
sudo apt-get upgrade
#更新系统和软件
sudo apt-get install mysql-server
#安装mysql服务端
sudo apt-get install mysql-client
#安装mysql客户端

3、查看mysql默认用户名和密码：
sudo cat /etc/mysql/debian.cnf
#里面有用户和密码

4、登录
mysql -u username -p password

5、查看数据库版本：
select version();

6、得知修改用户名密码的指令步骤为：
use mysql;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY “yushuhui”;
#修改密码为yushuhui
UPDATE user SET authentication_string=“” WHERE user=“root”;
#修改密码为空，下次登陆不需要密码。
SELECT user, authentication_string FROM user;
#查看加密后的密码是否为空，为空执行完后续步骤就可以不用密码登录。
FLUSH privileges;
quit;
#退出mysql

7、停止、启动mysql服务
service mysql stop
service mysql status
service mysql start

至此可以正常登陆。有截图请参考！！！！！