1 远程无法访问时,创建远程访问账户
创建用户
create user 用户名;
授权任意内容任意ip访问
grant all privileges on *.* to 用户名@"%" identified by '密码' with grant option;
刷新授权
flush privileges;
2 远程或者本地3306端口不开放时
编辑 /etc/mysql/mysql.conf.d/mysqld.cnf
将 bind-address 置为0.0.0.0
3 重新安装mysql
sudo rm /var/lib/mysql/ -R
sudo rm /etc/mysql/ -R
sudo apt-get autoremove mysql* –purge
sudo apt-get remove apparmor