Yet another "can't connect to MySQL over the network" question - but i seriously tried everything
- by mireille raad
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
I added a user with following priveleges :
+---------------+------------+
| host | user |
+---------------+------------+
| % | mir |
| 10.10.40.15 | mir |
| x.x.x.x | mir |
| localhost | mir |
Disabled firewall temporary
made sure that my username/password combinations are correct, flushed priveleges, restarted mysqld
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
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