Sorry nechce sa mi to prekladat ale vlozim sem text z mysql dokumentacie:
" The MySQL server listens on a single network socket for TCP/IP connections. This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces. The default address is 0.0.0.0. To specify an address explicitly, use the –bind-address=addr option at server startup, where addr is an IPv4 address or a host name. If addr is a host name, the server resolves the name to an IPv4 address and binds to that address. The server treats different types of addresses as follows:
1- If the address is 0.0.0.0, the server accepts TCP/IP connections on all server host IPv4 interfaces.
2- If the address is a “regular” IPv4 address (such as 127.0.0.1), the server accepts TCP/IP connections only for that particular IPv4 address."
Teda v skratke ak chce mat vzdialeny pristup k MySql serveru z viacerych IP je potrebne adresu nastavit na 0.0.0.0
V prvom rade pozri cez phpmadmin ci tam mas vytvorene tie dve databazy. ak tam nie si tak kodi nema spojenie so serverom.
" The MySQL server listens on a single network socket for TCP/IP connections. This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces. The default address is 0.0.0.0. To specify an address explicitly, use the –bind-address=addr option at server startup, where addr is an IPv4 address or a host name. If addr is a host name, the server resolves the name to an IPv4 address and binds to that address. The server treats different types of addresses as follows:
1- If the address is 0.0.0.0, the server accepts TCP/IP connections on all server host IPv4 interfaces.
2- If the address is a “regular” IPv4 address (such as 127.0.0.1), the server accepts TCP/IP connections only for that particular IPv4 address."
Teda v skratke ak chce mat vzdialeny pristup k MySql serveru z viacerych IP je potrebne adresu nastavit na 0.0.0.0
(27.3.2016, 21:16)Zdenci22 Napsal(a): Nemenil som tu bind adresu
Je to treba
V prvom rade pozri cez phpmadmin ci tam mas vytvorene tie dve databazy. ak tam nie si tak kodi nema spojenie so serverom.
HK Odroid N2+(ATV-LineageOS-20.0), 2 x Amlogic S905X4(CE),
HP t630[256Gb M.2 SSD, 16Gb RAM,Proxmox server](HAS;TVHeadend;MySQL;UniFi Controller;InfluxDB;Grafana)
Telestar DIGIBIT Twin
WD MyDrive 5TB
HP t630[256Gb M.2 SSD, 16Gb RAM,Proxmox server](HAS;TVHeadend;MySQL;UniFi Controller;InfluxDB;Grafana)
Telestar DIGIBIT Twin
WD MyDrive 5TB