Remote MySQL Access - IP/Host

[127.0.0.1]

I am trying to remotely access my MySQL database from my home computer with a program called navicat. It requires the Host name/IP address, my username, and my password. (User/Pass is same as cPanel, I know)

How do I find out the Host name/IP address? The program says there isn't a MySQL server at that host when I enter my site URL or heliohost.org. http://www.helionet.org/index/index.php?ac..._post&f=48#

[IDOXLR8]

Did you setup a new database from within cPanel?

I'm not sure if accessing remotely is allowed as I've never tried it from here.

there are a few things that you could do though.

 

try this:

http://www.idoxlr8.com/idoxlr8/server.php

 

get the script

http://www.idoxlr8.com/idoxlr8/server.txt

[Ashoat]

Your hostname should be stevie.heliohost.org. Your IP address should be 65.19.143.2.

[127.0.0.1]

I tried both of those, but it keeps giving me "2003 - Can't connect to MySQL server on host(hostname)". I set the remote access panel to allow 127.0.0.1, so it should work as far as I know.

Should I be using a port other than 3306?

[Ashoat]

Go to cPanel, and then select Remote Database Access Hosts. Enter your IP into there.

 

(Your IP isn't 127.0.0.1; that's localhost. It's not 192.168.*.* either. Google for "what is my IP" and pick the first result, and it will tell you.)

[127.0.0.1]

Okay, I did that, but I'm still getting the same error.

[jyanks]

Ok so here's what I'm using:

 

Host: http://stevie.heliohost.org

Port: 2082 (Using the default value gives me a different error)

 

Username/pw: CPanel Login credentials

 

 

Error:

"2013- Lost connection to MySQL server during query"

 

Any thoughts? I feel like that error message is better than an unable to connect like I was getting before

[Ashoat]

Jyanks: you are definitely using the wrong port. That error message just indicates that your MySQL "connection" message wasn't rejected, but that's only because you're talking to cpaneld and not mysqld on Stevie... cpaneld doesn't understand your message, so it probably ignores it or something.

 

I'll look into this on my own a little.

[jyanks]

  djbob said:

Jyanks: you are definitely using the wrong port. That error message just indicates that your MySQL "connection" message wasn't rejected, but that's only because you're talking to cpaneld and not mysqld on Stevie... cpaneld doesn't understand your message, so it probably ignores it or something.

 

I'll look into this on my own a little.

 

Oh darn. Well, any help would be GREATLY appreciated.

 

[Ashoat]

Since I can't figure out the problem on my own, I've submitted a support request to cPanel. It's probably a problem on their end. I'll let you know when they've figured it out.

[Ashoat]

Okay, cPanel reports the problem as fixed. How's it looking for you guys?

[jyanks]

  djbob said:

Okay, cPanel reports the problem as fixed. How's it looking for you guys?

 

Appears to be working, thank you.

[Amrutraj Gore]

Thank you. Thank you. Thank you.

I chose Helio for this particular post.

 

Host: stevie.heliohost.org worked for me. 65.19.143.2 didnt work. I have dynamic IP.

I am using python's MySQLdb module.

 

syntax::

 

conn = MySQLdb.connect(host='stevie.heliohost.org', user='*******',passwd='********',db='****')

 

 

 

  djbob said:

Your hostname should be stevie.heliohost.org. Your IP address should be 65.19.143.2.

[decho]

I have a problem with connection to MySql by SqlServer 2008. I am using as server: johnny.heliohost.org user/pass which i added in cPanel. But I am getting back an error: 'Cannot connect to johnny.heliohost.org' I also tried to use as server 'johnny.heliohost.org:2082' or server IP but it didn't work. Can anybody help me?

[jje]

Please don't bring back topics created nearly 2 years ago - just create another next time.

 

Anyway, have you clicked on 'Remote SQL' in your cPanel and typed in a % in the box (then pressed submit)?