cant access remote mysql server need help

Abhishek picture Abhishek · Jul 14, 2011 · Viewed 18.9k times · Source

I have a unix server with mysql which I am trying to access from my machine. To clarify, access the mysql server. When I do I get this error.

Connecting to MySQL server 192.168.1.25...
Can't connect to MySQL server on '192.168.1.25' (10061)

Here are my credentials:

username: root
port: 3306

The server is running because I am able to remotely login onto the machine (with ip: 192.168.1.25" and then run mysql from root. What do you think is going on:

  1. Is it a firewall issue?
  2. Accessing as 'root' is being denied?

I am new to mysql.

Answer

Gidon Wise picture Gidon Wise · Jul 14, 2011

1) check the logs you can see where the logs are by checking the my.cnf file. mysqld.log might be the file name, but where

2) a. see if it's a network issue.

telnet 192.168.1.25 3306

b. see if the service is at that port. ssh to the box # from the local host mysql -u root telnet 127.0.0.1 3306

ps auxw|grep mysql

you should hopefully have enough diagnostic info at this point to figure it out.