Again I have a problem with my special friend MySQL :D
I have got two servers - a database-server and a web-server - who are connected via VLAN.
Now I want the web-server to have remote access to the database-server's MySQL. So I created the user user in mysql.user.
user's Host is xxx.yyy.zzz.9 which is the internal IP-address of the web-server.
xxx.yyy.zzz.0 is the network. I also created user with Host % .
As long as I use MySQL on the database-server logging in as user, everything works fine. But trying to log in as user from xxx.yyy.zzz.9 using
mysql -h xxx.yyy.zzz.8 -u user -p
(where xxx.yyy.zzz.8 is the database-server's internal IP), I get
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.yyy.zzz.8' (110)
So I tried to activate
Bind-Address in the my.cnf file. Well, if I use xxx.yyy.zzz.8, nothing changes. But if I try xxx.yyy.zzz.9 and try to restart MySQL, I get
mysql stop/waiting start: Job failed to start
I checked the log files and found - nothing. The database-server's MySQL doesn't even register, that the web-server tries to connect remotely.
My idea is, that maybe I didn't configure the VLAN properley, even though I asked someone who actually knows such stuff and he told me, I did everything right.
What I wrote into
#The VLAN auto eth1 iface eth1 inet static address xxx.yyy.zzz..8 netmask 255.255.255.0 network xxx.yyy.zzz.0 broadcast xxx.yyy.zzz.255 mtu 1500
eth1 Link encap:Ethernet HWaddr xxxxxxxxxxxxxx inet addr:xxx.yyy.zzz.8 Bcast:xxx.yyy.zzz.255 Mask:255.255.255.0 inet6 addr: xxxxxxxxxxxxxxx/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:241146 errors:0 dropped:0 overruns:0 frame:0 TX packets:9765 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:17825995 (17.8 MB) TX bytes:566602 (566.6 KB) Memory:fb900000-fb920000
for the eth1, what is, what I configured. (This is for the database-server, the web-server looks similar).
ethtool eth1 returns:
Settings for eth1: Supported ports: [ TP ] Supported link modes: 10baseT/Half 10baseT/Full 100baseT/Half 100baseT/Full 1000baseT/Full Supported pause frame use: No Supports auto-negotiation: Yes Advertised link modes: 10baseT/Half 10baseT/Full 100baseT/Half 100baseT/Full 1000baseT/Full Advertised pause frame use: No Advertised auto-negotiation: Yes Speed: 100Mb/s Duplex: Full Port: Twisted Pair PHYAD: 1 Transceiver: internal Auto-negotiation: on MDI-X: Unknown Supports Wake-on: d Wake-on: d Current message level: 0x00000003 (3) drv probe Link detected: yes
(This is for the database-server, the web-server looks similar).
Actually I think, everything is right, but it still doesn't work. Is there someone with an idea?
I commented ou
Bind-Address in my.cnf after it didn't work.