配置MariaDB或MySQL可以遠端登入

1
/etc/my.cnf         (*nix/BSD)
2
$MYSQL_HOME/my.cnf  (*nix/BSD) *通常會是 /etc/mysql/my.cnf
3
SYSCONFDIR/my.cnf   (*nix/BSD)
4
DATADIR\my.ini      (Windows)

1
which mysqld
2

3
# 輸出為
4
/usr/sbin/mysqld

1
sudo /usr/sbin/mysqld --print-defaults
2

3
# 輸出為
4
/usr/sbin/mysqld would have been started with the following arguments:
5
--socket=/run/mysqld/mysqld.sock --pid-file=/run/mysqld/mysqld.pid --basedir=/usr --bind-address=127.0.0.1 --expire_logs_days=10 --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci

1
[mysqld]
2
...
3
skip-networking=0
4
skip-bind-address

1
[mysqld]
2
...
3
bind-address = 0.0.0.0

1
sudo /usr/sbin/mysqld --print-defaults
2

3
# 輸出為
4
/usr/sbin/mysqld would have been started with the following arguments:
5
--socket=/run/mysqld/mysqld.sock --pid-file=/run/mysqld/mysqld.pid --basedir=/usr --bind-address=127.0.0.1 --expire_logs_days=10 --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --skip-networking=0 --skip-bind-address
6

7
# 或是
8
/usr/sbin/mysqld would have been started with the following arguments:
9
--socket=/run/mysqld/mysqld.sock --pid-file=/run/mysqld/mysqld.pid --basedir=/usr --bind-address=127.0.0.1 --expire_logs_days=10 --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --bind-address=0.0.0.0

1
# 重啟MariaDB
2
sudo systemctl restart mariadb
3
# 停止MariaDB
4
sudo systemctl stop mariadb
5
# 啟動MariaDB
6
sudo systemctl start mariadb