Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to configure a freshly installed mysql server to listen on port 3306.

I've removed skip_networking, I have bind-address= and it completely ignores the config...

When I try SHOW VARIABLES LIKE 'skip_networking' I see it's still frustratingly ON.

netstat -na | grep mysql indicates it's listening on a random port, and yes, I do have port=3306 configured... Exact line is: unix 2 [ ACC ] STREAM LISTENING 45816 /var/run/mysqld/mysq d.sock

Running on Ubuntu 12.04.2

Am I missing something REALLY obvious?

share|improve this question
Are you certain you are editing the correct config file? This has bitten me maaaaany times. – BrianAdkins Apr 5 '13 at 21:42

On OSX system using macports

First kill your server if it is running.

mysqladmin shutdown -u root -p

Then Disable skip-networking from:


# skip-networking

Finally relaunch the server.

mysql -u root -p
share|improve this answer

The issue stems from your use of netstat. The clue is that your sample output starts with "unix" instead of "tcp" (i.e., it's a Unix socket, vice a network port). Instead of "netstat -an", try "netstat -antup" and grep for "mysql" or "LISTEN".

In other words, MySQL is no longer listening on a network port. What you're seeing is a Unix socket, which isn't accessible from the network. (Hope this helps.)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.