External Access to MySQL

[deadimp]

I've searched and found other posts on this, but none of them give me the same, definite answer.

How do we access our MySQL database externally [such as on a test server]? Namely, what is the host?
Are we even able to?

I'm asking because I usually manage my databases with a MySQL GUI, SQLyog, on my computer because I've accustomed myself to it, and it's simple for me to use.

 

[devin]

If you don't set it in cpanel, it'll reject all your connections.
But in cpanel 11 its easy to set up external mysql connections

"go to remote mysql in cpanel which is in the database section
then you add hosts.
If your test server is at 255.255.255.255
you'll put 255.255.255.255 as the host that is allowed to access

and usually to connect to the server it'll
assume your sub domain is at x10hosting

then it'll be username.x10hosting.com
then you database name ie:user_db
user: user_username
pass: pass

normally that would work.

 

[Corey]

Closing this since it seems to be answered.

-Corey

 

[deadimp]

I've just tried to access my MySQL account from my computer, and it still returns the same error...

 

[Corey]

I need to add your IP address to the firewall for you to be able to access SQL from outside the server. If you PM it to me I can do that.

 

[deadimp]

I've PMed the info to you.

 

[Corey]

Added to the firewall. Please reopen if further assistance is needed.