bruce@saba Posted April 28, 2006 Posted April 28, 2006 Good evening all, I'm trying to set up a remote connection to my domain's database but the connection just hangs. I have given the connection the IP address of my site and the port 3306, along with user id and password but I get no answer. Any suggestions or pointers to tutorials? I have enabled my computer in cPanel Tnx in advance bruce java script:emoticon('', 'smid_46') Quote
TCH-Tim Posted April 28, 2006 Posted April 28, 2006 Welcome to the forums Bruce. Do you get any errors when you try to connect, or does it just hang? What are you using to connect? Some script or program? To connect to your database from another server (or PC or whatever) you need to enter the IP address of that server in the "Access Hosts" section in the MySQL Account Maintenance, accessible through cPanel. Sounds like you may have already done that. Make sure your database username and password in whatever program or script it is you are trying to run is correct. Keep in mind that your database name will be in the form of cpaneluseraname_dbname and your database username will be in the form of cpanelusername_dbuser - essentially your database name and username are prefixed with your cPanel username. Your password, however, is not. Also be sure that your database user has been added to the database itself. Those are the basics off the top of my head. Double-check all that and let us know where you stand. Quote
TweezerMan Posted April 28, 2006 Posted April 28, 2006 After checking the things Tim has listed, if you still do not see any response from the server, one more thing to check is to make sure port 3306 is open in your firewall. The "I get no answer" makes me think your firewall could be blocking the connection, so whatever you're using to connect hangs because it's waiting for a response that's never going to come. Quote
TCH-Bruce Posted April 28, 2006 Posted April 28, 2006 Welcome to the forums Bruce! We can use a few more people named Bruce around here. We all know we have plenty named Robert! Quote
bruce@saba Posted April 28, 2006 Author Posted April 28, 2006 Hi, Thanks for the replies, but I'm still unable to connect. I am using mySQL Administrator to connect, and I can ping my site IP address. I gave the database access through cPanel to my machine, and now I am getting an error that the connection is refused , and the user is my user name , in the correct format, but the user name is followed by '@pool-168-161-206-28.ny325.east.verizon.net' . I am using a DSL line through verizon, could this be the problem? Quote
bruce@saba Posted April 28, 2006 Author Posted April 28, 2006 Hi,Thanks for the replies, but I'm still unable to connect. I am using mySQL Administrator to connect, and I can ping my site IP address. I gave the database access through cPanel to my machine, and now I am getting an error that the connection is refused , and the user is my user name , in the correct format, but the user name is followed by '@pool-168-161-206-28.ny325.east.verizon.net' . I am using a DSL line through verizon, could this be the problem? I got it, I had to use that string, I suppose the Verizon connection masks my local IP address , It works now though, thanks for you attention! Quote
TCH-Tim Posted April 28, 2006 Posted April 28, 2006 That would do it. Glad you got it sorted out. Quote
evaluateit Posted July 19, 2006 Posted July 19, 2006 (edited) I'm having the same issue. Would be grateful if you could tell me what you mean by 'I had to use that string' as I am getting a similar error message. Where did you put the string? (and which part of the string exactly?) Edited July 19, 2006 by evaluateit Quote
evaluateit Posted July 19, 2006 Posted July 19, 2006 I'm having the same issue. Would be grateful if you could tell me what you mean by 'I had to use that string' as I am getting a similar error message. Where did you put the string? (and which part of the string exactly?) Not to worry - sorted the problem - just used the '%' in the access hosts. Quote
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.