djet Posted January 19, 2008 Share Posted January 19, 2008 Hey is anyone here familiar with MySQL? I've been looking and I cannot find anything on the WWW on how to make it public. Google is too clogged with info about MySQL being a public database, but not anything about how to get it public so that others can access it. I'm pretty sure there is probably just a configure file that you replace localhost with your IP address, but I cannot seem to find it and didn't know if there was other stuff I had to do like which ports to open and such. Any help would be preeshed on this. Thanks in advance! Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/ Share on other sites More sharing options...
U.C. Posted January 19, 2008 Share Posted January 19, 2008 Well you can use PHPMyAdmin to enable others to run queries and stuff on it. Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/#findComment-585106 Share on other sites More sharing options...
glassJAw Posted January 20, 2008 Share Posted January 20, 2008 If you have a router, you can run a server off your computer be releasing your computer outside the router and firewall. I run a Apache server on my Windows XP virtual machine sometimes to show people stuff. Look up DMZ. Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/#findComment-585899 Share on other sites More sharing options...
lord_muad_dib Posted January 20, 2008 Share Posted January 20, 2008 DMZ access is excessive, it's a huge security hole, knowing your ip i could attack your server with just a couple of commands all depends on your needs, if you want to make it usable thru a web browser you need to open port 80 on your router if you just need to share the database for other purposes, you need to open mysql port(i don't remember it right now) Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/#findComment-586288 Share on other sites More sharing options...
djet Posted January 20, 2008 Author Share Posted January 20, 2008 SO all i gotta do is open up 3306 port (I think that's it.)? Nothing else like changing localhost or anything? Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/#findComment-586961 Share on other sites More sharing options...
osxfan156 Posted January 20, 2008 Share Posted January 20, 2008 Yep Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/#findComment-587139 Share on other sites More sharing options...
inimicus Posted January 24, 2008 Share Posted January 24, 2008 This doesn't make sense. Are you running MySQL on your personal machine and want to access your databases from outside your home network? Or is MySQL on your remote web server with a hosting company... and you want to do something... public... with it? Please, be more specific. Link to comment https://www.insanelymac.com/forum/topic/82410-public-mysql-database/#findComment-591898 Share on other sites More sharing options...
Recommended Posts