client/mysql -host=localhost -protocol=tcp -port=3306 test Using 'localhost' works when binding with bind_address: (my/maria-10.4). Telnet: connect to address 192.168.0.11: Connection refused client/mysql -host=myhost -protocol=tcp -port=3306 testĮRROR 2002 (HY000): Can't connect to MySQL server on 'myhost' (115) This for example will not work (connecting with a hostname that points to a local IP of the host): (/my/maria-10.4). If bind-address is bound to 127.0.0.1 (localhost), one can't connect to the MariaDB server from other hosts or from the same host over TCP/IP on a different interface than the loopback (127.0.0.1). One bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address Host, so you must remove this bind-address directive (MariaDB only supports This of course is not desirable if you want to use the TCP port from a remote IP address, or you will receive a fatal error and MariaDB will not start). Port on the server from a remote host (the bind-address must refer to a local Interface by default because it makes it impossible to connect to the TCP Network device and a physical Network Interface Card (NIC) which allows Server usually has at least two networking interfaces (although this is not
bind-address requires a little bit of background information.It just tells MariaDB to run without any of the TCP/IP networking options. Before going in to how to configure these, let's
Old MySQL packages sometimes disabled TCP/IP networking altogether using the skip-networking directive. Some MariaDB packages bind MariaDB to 127.0.0.1 (the loopback IP address) by defaultĪs a security measure using the bind-address configuration directive.
Granting User Connections From Remote Hosts.
0 kommentar(er)
