127.0.0.1 Posted June 26, 2009 Share 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# Quote Link to comment Share on other sites More sharing options...
IDOXLR8 Posted June 27, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Ashoat Posted June 27, 2009 Share Posted June 27, 2009 Your hostname should be stevie.heliohost.org. Your IP address should be 65.19.143.2. Quote Link to comment Share on other sites More sharing options...
127.0.0.1 Posted June 29, 2009 Author Share 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? Quote Link to comment Share on other sites More sharing options...
Ashoat Posted June 29, 2009 Share 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.) Quote Link to comment Share on other sites More sharing options...
127.0.0.1 Posted June 29, 2009 Author Share Posted June 29, 2009 Okay, I did that, but I'm still getting the same error. Quote Link to comment Share on other sites More sharing options...
jyanks Posted June 30, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 1, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
jyanks Posted July 1, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 1, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 2, 2009 Share Posted July 2, 2009 Okay, cPanel reports the problem as fixed. How's it looking for you guys? Quote Link to comment Share on other sites More sharing options...
jyanks Posted July 3, 2009 Share Posted July 3, 2009 Okay, cPanel reports the problem as fixed. How's it looking for you guys? Appears to be working, thank you. Quote Link to comment Share on other sites More sharing options...
Amrutraj Gore Posted July 14, 2010 Share 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. Quote Link to comment Share on other sites More sharing options...
decho Posted April 21, 2011 Share 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? Quote Link to comment Share on other sites More sharing options...
jje Posted April 22, 2011 Share 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)? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.