Jump to content

Recommended Posts

Posted

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

Posted

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?

Posted

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.)

Posted

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

Posted

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.

Posted
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.

 

Posted

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.

  • 1 year later...
Posted

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='****')

 

 

 

Your hostname should be stevie.heliohost.org. Your IP address should be 65.19.143.2.
  • 9 months later...
Posted

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?

Posted

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)?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...