Results 1 to 3 of 3

Thread: MYSQL remote connection probs.

  1. #1

    MYSQL remote connection probs.

    I am pulling my hair out trying to figure out why I cant connect remotely. I setup an account with % as the host in the user table. Locally(or with ssh) I can connect to the server fine. Remotely not a chance. I noticed that port 3306 is not showing up when I do netstat -a or lsof -i :3306. I tried starting the server like "mysqld --port=3306". Nada, port 3306 is not open. I cannot figure why. I am running Debian 3.0r1 on 2 machines and cannot connect to either of them(both running mysqld). Any suggestions?

    Thanks
    Jamin

  2. #2
    Mentor
    Join Date
    Jun 2001
    Posts
    1,672

    Re:MYSQL remote connection probs.

    The remote mysql connection is disabled by default in Debian for security reasons. All you need to do is comment out the 'skip-networking' option in /etc/mysql/my.cnf.

  3. #3

    Re:MYSQL remote connection probs.

    Dude I looked there for that option and just did not see it. I am a stupidhead. THANKYOU THANKYOU THANKYOU!!!!!!!!!!!!!!!!!!!!!!!! ;D

    Jamin

Similar Threads

  1. Remote Connection to MySql
    By honey bee in forum Redhat / Fedora
    Replies: 4
    Last Post: 03-17-2007, 06:40 PM
  2. configure Internet Connection Sharing in XP
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 01-04-2005, 06:29 AM
  3. Step-by-Step Guide to Remote Assistance
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 12-31-2004, 10:08 PM
  4. MySQL Error msgs
    By gmoreno in forum Announcements and Suggestions
    Replies: 4
    Last Post: 01-31-2003, 09:01 PM
  5. mysql installation instructions & permissions
    By elovkoff in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 02-06-2002, 10:51 AM

Bookmarks

Posting Permissions

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