+ 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
    Code:
    WIN IP:  192.168.1.2
    Linux IP:192.168.1.3
    in windows system:
    Code:
    GRANT ALL ON *.* TO 'parsa'@'192.168.1.3' IDENTIFIED BY 'parsa';
    flush all privileges;
    in my linux,in my.cnf I wrote this line in mysqld section
    Code:
    bind-address=192.168.1.2
    skip-networking was commented and I didn't change it I restarted the mysql

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

    command:net stats srv

    Statistics since 2/29/2012 4:52:22 PM
    Code:
    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
    Posts
    40
    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

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