Remote database connection

[Hitman]

Is it possable to connect to my mysql database remotely?

Whenever i try i get this error.

Access denied for user 'database_username'@'XX-XXX-XXX-XX.bitstream.orcon.net.nz' (using password: YES)


where database_username is....well what it says, and the XX-XXX is my ip.

[neednam]

Just out of curiosty do you have the mysql port opened, and fowarded? Last thing -- If it is linux be sure that the IP of which your requests are coming from are setup and approved for mysql.

[Ilya]

Remote connection is accessible only if server port was cofigured to remote access.

If the server is yours, make open the port 3306

PS. Use any one special software for testing connection (for Example SQL Maestro, EMS SQL Manager etc) :)

Ilya,
team of MySQL tools (http://second-mall.t35.com)

[Brandon]

Hello,

You are prompted with this error message:

Access denied for user 'database_username'@'XX-XXX-XXX-XX.bitstream.orcon.net.nz' (using password: YES)

when trying to connect remotely to your database, because you havent' added your IP in the cPanel -> MySQL Databases section.

In the end of the page there is a panel that says "Access Hosts"

You'll have to add your IP address in this list prior to connecting remotely to your database.

If your IP address is not static, but it's always in one range, for example it's changing from 67.10.1.1 to 67.10.1.12 you can add a wildcard:

67.10.1.%

Then all connections from the IP range between 67.10.1.* will be accepted.

If you need assistance in this operation, please feel free to post a support ticket and we'll help you.