127.0.0.1 Posted June 26, 2009 Posted June 26, 2009 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 Posted June 27, 2009 Posted June 27, 2009 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 Posted June 27, 2009 Posted June 27, 2009 Your hostname should be stevie.heliohost.org. Your IP address should be 65.19.143.2.
127.0.0.1 Posted June 29, 2009 Author Posted June 29, 2009 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 Posted June 29, 2009 Posted June 29, 2009 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 Posted June 29, 2009 Author Posted June 29, 2009 Okay, I did that, but I'm still getting the same error.
jyanks Posted June 30, 2009 Posted June 30, 2009 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 Posted July 1, 2009 Posted July 1, 2009 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 Posted July 1, 2009 Posted July 1, 2009 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 Posted July 1, 2009 Posted July 1, 2009 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 Posted July 2, 2009 Posted July 2, 2009 Okay, cPanel reports the problem as fixed. How's it looking for you guys?
jyanks Posted July 3, 2009 Posted July 3, 2009 Okay, cPanel reports the problem as fixed. How's it looking for you guys? Appears to be working, thank you.
Amrutraj Gore Posted July 14, 2010 Posted July 14, 2010 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.
decho Posted April 21, 2011 Posted April 21, 2011 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 Posted April 22, 2011 Posted April 22, 2011 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)?
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now