+ Reply to Thread
Results 1 to 2 of 2

Thread: can't connect to mysql

  1. #1

    can't connect to mysql

    I have a client on linux and the mysql server on windows

    I wanted to connect to mysql remotely 2 computers can ping each other without any problem in mysql server I set the permission correctly so the specified client is allowed to connect
    WIN IP:
    Linux IP:
    in windows system:
    GRANT ALL ON *.* TO 'parsa'@'' IDENTIFIED BY 'parsa';
    flush all privileges;
    in my linux,in my.cnf I wrote this line in mysqld section
    skip-networking was commented and I didn't change it I restarted the mysql

    when I use
    telnet 3306 
    telnet:connect to address timed out
    and using this command:
    mysql -h -u parsa -p parsa
    Error 2003:can't connect to mysql server on
    The firewalls in both sides are disabled what should I do?

    command:net stats srv

    Statistics since 2/29/2012 4:52:22 PM
    Sessions accepted                  1
    Sessions timed-out                 0
    Sessions errored-out               0
    Kilobytes sent                     0
    Kilobytes received                 0
    Mean response time (msec)          0
    System errors                      0
    Permission violations              0
    Password violations                0
    Files accessed                     0
    Communication devices accessed     0
    Print jobs spooled                 0
    Times buffers exhausted
      Big buffers                      0
      Request buffers                  0
    The command completed successfully.

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Connection timed out can mean two things:
    1) Your server is too busy to respond
    2) There is a firewall between your client computer and the server which blocks the connection.

    To see how busy the server is, use uptime. Load average > 10 means "busy". Load average < 1 means "idle".

    If the server is idle, check for the firewall settings on the server, then check the client.

+ Reply to Thread

Tags for this Thread


Posting Permissions

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