Search code examples
mysqlmysql-error-2003

cant access remote mysql server need help

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.

Solution

  • Probably because remote root login is not allowed. You can try this article on how to enable remote root:

    http://benrobb.com/2007/01/15/howto-remote-root-access-to-mysql/