腾讯云或者阿里云navicat远程连接mysql（ubuntu）

//确保阿里云服务器或者腾讯云服务器开启了端口
//确保注释 /etc/mysql/mysql.conf.d/mysqld.cnf 下
# bind-address          = 127.0.0.1
#  mysqlx-bind-address  = 127.0.0.1
//打开mysql,输入命令：
CREATE USER 'username'@'localhost' IDENTIFIED BY 'Mysql@123';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

CREATE USER 'username'@'%' IDENTIFIED BY 'Mysql@123';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

//在mysql当中创建了一个用户名为username，密码为Mysql@123的用户，并且授予用户远程登录的权限

navicat远程连接，ok