Remote connection

[xcensus]

Hi,

I have a client that needs to convert a mssql to mysql database, he has the application that does this, but is getting errors when he tries to remotely connect to the database, he is using the reseller IP I allocated him and the port 3306, but gets the error ... Host 'some ip' is not allowed to connect to database, what maybe the problem and the solution ?

Thanx

 

[fusionictnl]

Standard only localhost and 127.0.0.1 (localhost) is allowed to connect to MySQL. To allow your client to connect remotely to the MySQL you'll have to add him with his IP.

You can do this easy with phpMyAdmin wich is under Mysql Management in DA and add him as Host under his user rights.

Good luck

 

[DirectAdmin Support]

Hello,

Another easy way to allow his IP access is using the "Access Hosts" feature in the mysql menu through DA.

User Panel -> MySQL Databases -> username_database -> Access Hosts -> Add his IP.

John

 

[nobaloney]

And don't forget you may need to open a hole in your firewall.

Jeff