零，報(bào)錯(cuò)日志?2002-Can’t?connect?to?server?on’106.54.209.77’(1006x)

今天差點(diǎn)被這個(gè)報(bào)錯(cuò)給折磨瘋掉

嘗試一：對(duì)騰訊云服務(wù)器進(jìn)行更改

嘗試二：針對(duì)配置文件處理

step1

//確保注釋 /etc/mysql/mysql.conf.d/mysqld.cnf 下# bind-address          = 127.0.0.1#  mysqlx-bind-address  = 127.0.0.1

step2?重新加載服務(wù)器配置文件

sudo systemctl daemon-reload

step3

sudo systemctl restart mysql

嘗試三：開啟MySQL的遠(yuǎn)程訪問權(quán)限

USE mysql;
CREATE USER 'root'@'%' IDENTIFIED BY '密碼';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
select user,host from user;

順便對(duì)于vscode

順便今天似乎vscode連接不上ubuntu，是因?yàn)閬y處理上面的問題，給出如下方法

sudo ufw enable
#Command may disrupt existing ssh connections. Proceed with operation (y|n)? y
#Firewall is active and enabled on system startup