Results 1 to 5 of 5

Thread: Unable to connect to RH8 MySQL box from Windows

Hybrid View

  1. #1
    Junior Member
    Join Date
    Jun 2001
    Location
    Melbourne, Australia
    Posts
    94

    Unable to connect to RH8 MySQL box from Windows

    I have MySQL installed on RH8, and am able to connect locally to the server, but cannot connect from my Windows box using MySQLCC, or MySQLGui. I get a "Lost connection to MySQL server during query" message on both clients. Port 3306 is open, I have an entry in the user table with the Host set to '%', but no joy.

    If I attempt to Telnet to port 3306 from the Windows machine, I get "Connection to host lost" immediately, doing the same from the linux box gives me:
    [pre]
    [davidn@tron etc]$ telnet localhost 3306
    Trying 127.0.0.1...
    Connected to localhost.
    Escape character is '^]'.
    (
    3.23.52H.O$bBbI,Connection closed by foreign host.
    [davidn@tron etc]$
    [/pre]
    Anyone have any clues why I cannot connect remotely?

    Here is copy of /etc/my.cnf :
    [pre][mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    [/pre]

  2. #2
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760

    Re:Unable to connect to RH8 MySQL box from Windows

    hmmm ... is your firewall AND /etc/hosts.allow AND /etc/hosts.deny set appropriately?

    like is it just MySQL that doesnt work right or SSH/Telnet ?

  3. #3
    Junior Member
    Join Date
    Jun 2001
    Location
    Melbourne, Australia
    Posts
    94

    Re:Unable to connect to RH8 MySQL box from Windows

    Schotty - I am able to connect via SSH and Telnet with no problems. The box also does Samba file sharing, DNS, DHCP, SMTP, POP3 and HTTP, all trouble free.

    I'm guessing that there is some setting somewhere that I have to define to allow the client to connect to the server, but I've never had this sort of trouble before.

    I know I would be able to use phpMyAdmin to do this, but the MySQLcc interface is so much nicer (and a hell of a lot easier to use).

  4. #4
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760

    Re:Unable to connect to RH8 MySQL box from Windows

    Look up the command grant. You will need to execute a grant priveledges from all users and for each machine (wildcards do work to make life simpler or possibly insecure and shitty ;D ).


  5. #5
    Junior Member
    Join Date
    Jun 2001
    Location
    Melbourne, Australia
    Posts
    94

    Re:Unable to connect to RH8 MySQL box from Windows

    I had already created a user with the command:
    [pre]INSERT INTO mysql.user SETHost = '%',
    User = 'monty',

    Password = PASSWORD( '*******' ) ,
    Select_priv = 'Y',
    Insert_priv = 'Y',
    Update_priv = 'Y',
    Delete_priv = 'Y',
    Create_priv = 'Y',
    Drop_priv = 'Y',
    Reload_priv = 'Y',
    Shutdown_priv = 'Y',
    Process_priv = 'Y',
    File_priv = 'Y',
    Grant_priv = 'Y',
    References_priv = 'Y',
    Index_priv = 'Y',
    Alter_priv = 'Y' [/pre]
    to no avail.

    I am still nowhere with this, and would really like to use MySQLCC over phpmyadmin.

    I used to use MySQLGui with MySQL on SuSE 8.0, so I am guessing that there is something on RH8 that requires setting. I should point out that I have no firewall on either the database server or the Windows client machine.

Similar Threads

  1. Unable to configure SFU3.5 for Windows 2008 server
    By vakkarao in forum Redhat / Fedora
    Replies: 0
    Last Post: 03-21-2012, 12:46 PM
  2. Unable to connect to wired Network
    By Randy Jackson in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 01-17-2007, 05:24 AM
  3. unable to authenticate to windows 2000 dc
    By shashank in forum Linux - General Topics
    Replies: 0
    Last Post: 03-24-2005, 08:56 AM
  4. Unable to Connect to Stand-Alone SQL Server
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 01-01-2005, 09:41 PM
  5. Unable to connect to some sites
    By trickster in forum Linux - Hardware, Networking & Security
    Replies: 7
    Last Post: 09-11-2002, 02:15 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
  •