How to: Use seperate local MySQL DB
Submitted by Easton on Mon, 04/27/2009 - 18:32
This was quite frustrating for me. I tried everything; why doesn't it connect to to the database? I finally figured it out: wrong IP. Anyway, here are some tricks that I used to get Server A to connect to Server B, with MySQL.
First things first. Change your bind-address. For Debian, edit your my.cnf in /etc/mysql
Change the bind-address to your local LAN IP. Restart MySQL with: