1、修改端口
2、远程+开放端口
(1)设置远程账号:xxx和密码yyyyyyy
grant all privileges on *.* to 'xxx'@'%' identified by 'yyyyyyy';
flush privileges;
(2)开放端口
防火墙开放新端口
参考:
https://www.howtoing.com/change-default-mysql-mariadb-port-in-linux
1、修改端口
2、远程+开放端口
(1)设置远程账号:xxx和密码yyyyyyy
grant all privileges on *.* to 'xxx'@'%' identified by 'yyyyyyy';
flush privileges;
(2)开放端口
防火墙开放新端口
参考:
https://www.howtoing.com/change-default-mysql-mariadb-port-in-linux