Find the answer to your Linux question:
Results 1 to 6 of 6
I just installed Fedora 14 in a hard disk of my PC. I installed MySQL also. I dontīt know if this is the correct site for my question, but nobody ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jun 2007
    Posts
    7

    TCP/IP connections in Fedora 14


    I just installed Fedora 14 in a hard disk of my PC. I installed MySQL also. I dontīt know if this is the correct site for my question, but nobody MySQL related, have an answer yet. For MySQL accepting remote connections, my.cnf file must be edited (bind-address line or skip-networking line in that file). Well, that file in my Fedora-MySQL installation does not have such lines, so i assume, TCP/IP connections are allowed in MySQL. When i try to connect to the MySQL server it refuses the connection with the error 2003, that in short, means no TCP/IP connections are allowed. I disabled the firewall and retried but with no success, enabled the firewall again, and nothing happen. Is Fedora not accepting TCP/IP connections?

    Can anybody suggest me any action?. Thanks a lot, and sorry for my english.

  2. #2
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,425
    is it started?
    ps auwx |grep sql

    does it listen?
    netstat -tunlp |grep sql
    You must always face the curtain with a bow.

  3. #3
    Just Joined!
    Join Date
    Jun 2007
    Posts
    7
    Thank you for your answer. Yes the MySQL server is up and listening at the 3306 port.

  4. $spacer_open
    $spacer_close
  5. #4
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,425
    ok, so can you telnet to 127.0.0.1 3306?
    and if that works
    mysql -h 127.0.0.1 -u <user> -p
    You must always face the curtain with a bow.

  6. #5
    Just Joined!
    Join Date
    Jun 2007
    Posts
    7
    Yes it was possible to connect to MySQL .

    This was the result of netstat -tunlp |grep sql

    tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1393/mysqld

    The commands were run in two ways:

    1) At a local terminal
    2) At a remote ssh session

    With the same results

    With telnet 127.0.0.1 3306 the result was:

    Trying 127.0.0.1...
    Connected to 127.0.0.1.
    Escape character is '^]'.
    4
    5.1.52T2?$5!AU]TnKkY\Br;k

    And hitting Enter (i.e.):

    Connection closed by foreign host.

  7. #6
    Just Joined!
    Join Date
    Jun 2007
    Posts
    7

    Wink Solved

    I solved the problem: i added the port 3306 with the procols udp and tcp to the firewall, and now the remote connections go well. And only root has remote access by now. Thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •