Mysql – Connect to MySql on other machine on LAN

databaseMySQL

I am facing problem with connecting MySql database on the other machine on the same network.

Could not connect to the specified instance. MySql error number 1130 Host 'abc' is not allowed to connect to this MySql server (Pinging ok time 1-3 ms ttl =128)

I have check out the followings:

Tcp/IP enabled
RegEdit under hlocal machine …. parameters .. maxUserpORT And timedelay..
Grant all . to 'root'@'Myipaddress'
please help to the earliest..

Best Answer

The error message you're getting shows that you correctly made the connection to port 3306 on the remote server. Your network settings are therefore fine.

What you have is an ACL problem - "Host 'abc' is not allowed to connect to this MySql server".

I'm a little rusty on MySQL ACLs, but instead of granting access to 'root'@'my.ip.address', try granting it to 'root'@'abc'

Related Solutions

Ssh – Use Windows/Mac MySQL GUI over SSH Tunnel

ssh -L9999:mysqlserver.com:3306 joe@thehost.com

then tell your MySQL Gui to connect to localhost:9999

Centos – Can’t connect to MySql server on remote server

Check my.conf and what bindings MySql server has.

It may be so, that it listens only on the local network.

You are looking for bind-address setting in /etc/my.conf or /etc/mysql/my.conf.

If this setting is enabled (usually to bind to only localhost 127.0.0.1), comment it out, and it will allow MySql to listen on all available interfaces.

In any case, accessing the database server directly over Internet is not a good idea at all.

I would strongly advice you to use ssh tunneling to access the machine over Internet.

On windows, you can use putty to ssh (creating a tunnel) into the MySql machine. You can forward your local 3306 port to the remote one, and then you can access the MySql server using localhost:3306.

Best Answer

Related Solutions

Ssh – Use Windows/Mac MySQL GUI over SSH Tunnel

Centos – Can’t connect to MySql server on remote server

Related Topic