mariadb mysql远程登陆&mariadb mysql远程登陆失败

mysql设置

GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'qwe123' WITH GRANT OPTION;
flush privileges;
quit;

即成功

若失败
1、检查云服务器的端口3306是否有开启
2、注释绑定监听地址

ls /etc/mysql/

cd /etc/mysql/mariadb.conf.d/

ls

sudo nano 50-server.cnf

在bind-address=127.0.0.1前面加#注释掉