by dmphotography » 04. February 2009 23:10
My recommendation is why not put a MySQL database server on your Mac and save yourself the headaches? I personally tried remotely connecting to a MySQL databse a short while back and couldn't get it to work, so I recommend just installing XAMPP on your MAC so you can use that program instead of trying to access a MySQL database across your network.
In regards to your My.cnf file post, port = 3306 is telling the MySQL server what port to run on. In the event you needed to run a second or multiple MySQL servers on the same computer, you would simply configure them to run on different ports. 3306 is considered the default port for MySQL servers.
What Izzy suggested should work if it's going to work. Normally most personal/home routers don't block ports over the LAN, but you can check that and make sure port 3306 is forwarded to your computer with the MySQL server on it.
I still recommend doing a quick install of XAMPP and then removing it when you're done if you don't want to keep it. You can do what you're trying to do without any configuration to XAMPP, just a straight install.
For great video and written tutorials and guides on creating your own web server and installing things such as forums, blogs, etc., visit
http://myownhomeserver.com