Linux - NewbieThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
mysql> SHOW VARIABLES LIKE 'skip_networking';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| skip_networking | OFF |
+-----------------+-------+
and, port 3306 is definitely appears in /etc/my.cnf
My only guess is iptables but as far as I can tell, all ports are accepted.
Here is my iptables -L :
Chain INPUT (policy ACCEPT)
target prot opt source destination
DROP all -- anywhere anywhere state INVALID
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT all -- anywhere anywhere
ACCEPT icmp -- anywhere anywhere
ACCEPT tcp -- anywhere anywhere tcp dpt:http
ACCEPT tcp -- anywhere anywhere tcp dpt:https
ACCEPT tcp -- anywhere anywhere tcp dpt:ssh
DROP tcp -- anywhere anywhere tcp dpts:tcpmux:65535
DROP udp -- anywhere anywhere udp dpts:tcpmux:65535
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql
I had the same problem in ubuntu, and went to edit the same file.
now in ubuntu it looks a bit different than skip-networking. This is how it looks:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
so I replaced bind-address localhost ip with the right ip, mysql restart and that was it.
woulndt be for this post I wouldnt have found that...
thanks guys
I struggled with this for three days now, then I found this awesome thread
on my freeBSD changing the configuration files mentioned didn't help, I also had to change the file " /var/db/mysql/my.cnf"
Im using SMS distro for servers, and I have a lot of hours looking and looking for info, I was checking firewall, Ports, config from phpmyadmin, and nothing...
So I read something about to comment the line with 'skip_networking' but I also found it on my.cnf
Finally thanks to you, I look on /etc/rc.d/rc.mysql and there!
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.