Find the answer to your Linux question:
Results 1 to 5 of 5
I've got MySQL installed and running, but now I need to make it accessible to the Internet. I've set my router to run mysql through port 3306, but what do ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie
    Join Date
    Oct 2006
    Posts
    109

    mysql server....


    I've got MySQL installed and running, but now I need to make it accessible to the Internet. I've set my router to run mysql through port 3306, but what do I need to do to Linux to make it work??

    /etc/services reads
    Code:
    mysql           3306/tcp                        # MySQL
    mysql           3306/udp                        # MySQL
    I'm running Fedora Core 6. Is there something else I need to do?

    Thanks.

  2. #2
    Linux Newbie
    Join Date
    Oct 2006
    Posts
    109

    Question

    FYI, when I try to connect to the server from my windows machine, here's what happens...

    Code:
    C:\Documents and Settings\Don>mysql -u root -h the24hourshow.net -p
    Enter password: *******
    ERROR 2003 (HY000): Can't connect to MySQL server on 'the24hourshow.net' (10060)
    Below is the /etc/my.cnf file
    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=0
    
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    and
    Code:
    [root@localhost etc]# netstat -lnp | grep mysql
    tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      8927/mysqld
    unix  2      [ ACC ]     STREAM     LISTENING     136651 8927/mysqld         /var/lib/mysql/mysql.sock
    So it's installed and running...I just can't figure out why it's not accepting remote connections....

  3. #3
    Just Joined!
    Join Date
    Jun 2006
    Location
    (.)
    Posts
    69
    Have you allowed root user to connect to your mysql server from your local system IP address?


    Or you need to allow root user to connect from anyhost..

    Thx

  4. $spacer_open
    $spacer_close
  5. #4
    Linux Newbie
    Join Date
    Oct 2006
    Posts
    109
    I wound up having to edit system-config-something or other to allow port 3306 to come through...weird, but oh well...thanks...

  6. #5
    Just Joined!
    Join Date
    Oct 2006
    Posts
    9
    I wound up having to edit system-config-something or other to allow port 3306 to come through
    Can remember what you did exactly? I'm having this problem - exactly the same - and I've been trying to fix it all week, it's killing me!

Posting Permissions

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