LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-29-2012, 04:54 AM   #1
snooze1
Member
 
Registered: Sep 2011
Posts: 34

Rep: Reputation: Disabled
MySQL not allowing remote connections, iptables has been removed.


I have installed MySQL, php, and phpMyAdmin. I'm setting up a user that allows from '%' (any) and it's not working. I created a DB and it's not allowing me to remotely connect, I have gotten to the point where I have just completely removed iptables and restarted.

Using Debian.
 
Old 05-29-2012, 05:36 AM   #2
fukawi1
Member
 
Registered: Apr 2009
Location: Melbourne
Distribution: Fedora & CentOS
Posts: 854

Rep: Reputation: 190Reputation: 190
I would start by checking if mysql is listening as it should be using netstat.
Code:
netstat -tnlp | grep 3306
And check the "bind-address" directive in my.cnf, making sure mysql is listening on the right address..

Since you don't say how you are trying to connect remotely, and I am unfamiliar with phpMyAdmin, all I can really suggest is to try getting back to basics, try telnet'ing the mysql server to try and isolate whether the problem is phpMyAdmin not connecting or if mysql is not listening.
 
Old 05-29-2012, 05:47 AM   #3
snooze1
Member
 
Registered: Sep 2011
Posts: 34

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by fukawi1 View Post
I would start by checking if mysql is listening as it should be using netstat.
Code:
netstat -tnlp | grep 3306
And check the "bind-address" directive in my.cnf, making sure mysql is listening on the right address..

Since you don't say how you are trying to connect remotely, and I am unfamiliar with phpMyAdmin, all I can really suggest is to try getting back to basics, try telnet'ing the mysql server to try and isolate whether the problem is phpMyAdmin not connecting or if mysql is not listening.
I'm trying to connect from a php server. Running that netstat it gives me

Code:
tcp        0      0 23.19.48.147:3306       0.0.0.0:*               LISTEN      
1468/mysqld
I have binded the server on the above IP aswell in the my.cnf and turned off skip-networking, and it's still not working unfortunately.
 
Old 05-29-2012, 05:55 AM   #4
fukawi1
Member
 
Registered: Apr 2009
Location: Melbourne
Distribution: Fedora & CentOS
Posts: 854

Rep: Reputation: 190Reputation: 190
You still haven't said how you are trying to connect (method, commands, error messages, etc)

Try port scanning the server from the client, and telneting, if the former shows port 3306 open, and the latter connects, then i would suggest installing and running mysql (client) on the client machine, and trying to connect directly with mysql..

If all that works, I would say the problem lies with the configuration of phpMyAdmin.

I am not an expert on mysql or phpMyAdmin, so aside from the network connectivity side of things, I cant really help.

Last edited by fukawi1; 05-29-2012 at 05:56 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL will not allow remote connections, iptables is disabled, CentOS 5.6. snooze1 Linux - Newbie 7 04-06-2012 11:42 AM
Iptables isn't allowing any outgoing connections lemx Linux - Security 1 04-10-2009 10:41 PM
iptables problem allowing incoming connections ikinnu Linux - Networking 1 07-17-2008 06:42 AM
Allowing connections to port 8080 in iptables apache363 Linux - Software 1 10-12-2004 03:14 PM
MySQL not allowing connections from Applet peteABK Linux - Newbie 1 11-04-2003 10:29 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:57 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration