I got two Debian 6 servers - one for web and one for the database..
How can I connect through the local area network?
On both servers I have permanently changed the hostnames
/etc/hostname /etc/hosts web => web-server db => db-server
In the privileges in mysql I have set the root user to accept requests from
web-server (instead of localhost) and from the web-server I connect to
my.cnf I have escaped the following line:
# bind-address = 127.0.0.1
Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host 'db-server' (1)