对于已经有数据的数据库

1. 备份原有的数据库sql文件
2. 卸载原有的数据库

查看依赖项

dpkg --list|grep mysql

卸载(将所有依赖项通过以下命令删除)

sudo apt-get remove mysql-common
sudo apt-get autoremove --purge mysql-server
sudo apt-get autoremove --purge mysql-apt-config

4. 重新安装mysql

5. 从官网下载对应的安装包.deb

6. sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

8. 

9. 

sudo apt-get upgrade

在安装前把my.cnf下面的修改以下内容

[mysqld]
 
lower_case_table_names = 1

安装mysql

sudo apt install mysql-server

设置密码

选择Use Strong Password Encryption (RECOMMENDED)

systemctl start mysql

mysql8 修改root远程连接权限

CREATE USER ‘root’@’%’ IDENTIFIED BY ‘Hadoop3!’;
grant all privileges on . to ‘root’@’%’;
alter user ‘root’@’%’ identified with mysql_native_password by ‘Hadoop3!’;
flush privileges;