//确保阿里云服务器或者腾讯云服务器开启了端口
//确保注释 /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
腾讯云或者阿里云navicat远程连接mysql(ubuntu)
于 2022-01-07 15:10:15 首次发布