Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19
Remote Connection to MySql
Results 1 to 5 of 5

Thread: Remote Connection to MySql

  1. #1
    Member honey bee's Avatar
    Join Date
    Feb 2006
    Location
    Pakistan
    Posts
    146

    Question Remote Connection to MySql

    Hello,

    I want to connect to mysql from remote server.When i telnet, i get the following:

    telnet 127.0.0.1 3306
    Trying 127.0.0.1...
    Connected to localhost.localdomain (127.0.0.1).
    Escape character is '^]'.
    Some garbage values:

    4
    4.1.11`RYG:*b0h<1~L?74?~#+
    and after 2-3 seconds connection is closed automatically.

    Connection closed by foreign host.
    Can anyone tell me, what's the problem?

  2. #2
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760
    Out of curiousity, what would happen if you hit the real IP of the machine? Such as you have 1.2.3.4 as your IP, what would

    telnet 1.2.3.4

    Do? Also I would kill iptables for now to ensure that the firewall isn't blocking you.

    To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


  3. #3
    Member honey bee's Avatar
    Join Date
    Feb 2006
    Location
    Pakistan
    Posts
    146
    I get the same situation with the ip-address.The firewall is disabled.

  4. #4
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760
    how did you install mysql? If you used the rpms from Fedora or Red Hat, did you initialize any users or a database?

    If you didn't, I would refer to the following resource for some quick tips:
    http://www.reallylinux.com/docs/basicmysql.shtml

    To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


  5. #5

    I don't recall if i had this exact problem...

    I was trying to use mysql as a remote web server and one of the key things to getting it working was disabling SELinux. I am using Fedora so the file is "/etc/selinux/config". You want to change the line "SELINUX=enforcing" to "SELINUX=disabled". Then bounce the machine. From then on it will boot with out SELinux. Hopefully helpful. Also have you tried to ssh into the machine and then run mysql. If this doesn't work you will need to add the host you are connecting from to the list of allowed hosts in the mysql database.

Similar Threads

  1. Replies: 0
    Last Post: 12-06-2007, 04:52 PM
  2. Problem starting mysql conflicts with the RPM "mysql-5.0.27-1.fc6"
    By kamakshiganesh in forum Redhat / Fedora
    Replies: 2
    Last Post: 10-26-2007, 04:35 AM
  3. Remote applications, Actually remote Windows Question.
    By Stevef22 in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 11-05-2006, 06:11 AM
  4. Remote Web Connection
    By carlos0330 in forum Windows - General Topics
    Replies: 0
    Last Post: 03-01-2005, 08:38 AM
  5. MYSQL remote connection probs.
    By HuggyBear in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 03-04-2003, 11:51 PM

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
  •