Problem with external connections to MySQL.

3 posts / 0 new

Topic locked

#1 Tue, 03/10/2009 - 13:52

maxp1

Problem with external connections to MySQL.

I think there's something incredibly basic I'm missing here. I can't access a MySQL database with an external script. Internal (same server) scripts are fine. I've enabled access for the IP address and user, but can't connect.

Importantly, I can't telnet to port 3306. I think this is actually what is going on (or at least a good place to start), the port isn't open.

Also, as an aside, the search function on the forum isn't very useful. I'm sure someone has encountered this kind of before but I couldn't find anything without paging through all the old posts.

#2 Sun, 06/07/2009 - 07:35

ronald

have you tried opening the port in the firewall with the IP it has to connect to? Does the other side allow traffic that port too?

#3 Tue, 03/10/2009 - 14:27

maxp1

Thanks for the reply Ronald. Of course after many hours of frustration I managed to answer my own question a few minutes after posting this. Open port in IPTables and restart mysql.

If you've got another second though, when I log in as the user I've set up from my remote computer I'm able to access INFORMATION_SCHEMA even though I've restricted access to just the one database that I want to see. Theoretically it shouldn't matter since I'll be the only one poking around with this user, but it would be nice to not see it at all. Any clues?

Thanks.

Topic locked