Hello,

I was left with the easy task of installing moodle.

I am VPNing to 2 servers, one for the database and the other apache/php

server 1 must connect over LAN to the mySQL db on server 2

1. I added a user with following priveleges : +---------------+------------+ | host | user | +---------------+------------+ | % | mir | | 10.10.40.15 | mir | | x.x.x.x | mir |
   | localhost | mir |

2. Disabled firewall temporary

3. made sure that my username/password combinations are correct, flushed priveleges, restarted mysqld

4. i wnt to /etc/my.cnf .. if i try to add the port=3306 bind-address=10.10.40.15 or anything that is different from 0.0.0.0 or 127.0.0.1 - mysql wouldn't restart

5. i read and tried many forums and pages and asked friends for tips but nothing works

So my question to you :

• are there any networking extensions that need to be installed for mysql, how do i know nothing is missing from the installation
• any troubleshooting tips, any idea how to fix this, any step by step check list, am i missing something simple/stupid, please anything that comes to mind, let me know

Appreciate your feedback on this friday night stuck at work :P