ubuntu安装mysql8_ubuntu 解压版本mysql8

卸载mysql

https://blog.csdn.net/syrchina/article/details/121440549

sudo apt-get autoremove --purge mysql-server 
sudo apt-get remove mysql-common
sudo rm -rf /etc/mysql/ /var/lib/mysql
dpkg -l | grep ^rc| awk '{print $2}' | sudo xargs dpkg -P
sudo apt autoremove
sudo apt autoclean
1
2
3
4
5
6

安装mysql

wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server
1
2
3
4

运行远程登录

参考：
https://blog.csdn.net/weixin_44215249/article/details/120482604

//查看思否运行远程
SELECT user,host,authentication_string,plugin FROM mysql.user;
// 创建用户  并运行远程连接
CREATE USER 'root'@'%' IDENTIFIED BY 'root';
grant all on *.* to 'root'@'%';
flush privileges;
quit;
UPDATE mysql.user SET `plugin`='mysql_native_password' WHERE `user`='root';
flush privileges;
quit;
1
2
3
4
5
6
7
8
9
10