操作系统:ubuntu
1.sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf
注释掉bind-address=127.0.0.1这行
2.GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
3.FLUSH PRIVILEGES;
参考链接:
https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/