Error No. 2005: Unknown Mysql Server Host

[Brian Lovett]

Just downloaded community beta 8.13. I am using powweb as hosting provider. They tell me host address is [username].powwebmysql.com. They do allow remote connections. I have read (multiple times) the post at http://www.webyog.com/faq/content/23/17/en…ht=error%202005. They tested doing a remote connection and it worked (though they wouldn't load SQLyog to try because they don't support 3rd-party apps.) I'm using McAfee as a firewall, but have turned it off. Still getting this error.

Is anyone using powweb as a hosting provider that knows how to get this to connect? Are there any other ways I can troubleshoot to see where the problem is occurring? I can't figure out if I want to buy this if I can't even connect. Thanx.

– B.

[Brian Lovett]

Brian Lovett wrote on Jul 1 2009, 01:07 PM:

Just downloaded community beta 8.13. I am using powweb as hosting provider. They tell me host address is [username].powwebmysql.com. They do allow remote connections. I have read (multiple times) the post at http://www.webyog.com/faq/content/23/17/en…ht=error%202005. They tested doing a remote connection and it worked (though they wouldn't load SQLyog to try because they don't support 3rd-party apps.) I'm using McAfee as a firewall, but have turned it off. Still getting this error.

Is anyone using powweb as a hosting provider that knows how to get this to connect? Are there any other ways I can troubleshoot to see where the problem is occurring? I can't figure out if I want to buy this if I can't even connect. Thanx.

– B.

Just as a follow-up, this is the php script that powweb used to test that the connection is working:

Code:

// hostname or ip of server
$host = '[username].powwebmysql.com';
// username and password to log onto db server
$dbuser = '[database user name]';
$dbpassword = '[database password]';
// name of database
$dbname = '[database name]';
////////////// Do not edit below/////////
connecttodb($host,$dbname,$dbuser,$dbpassword);
function connecttodb($host,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect (“$host”,”$dbuser”,”$dbpassword”);
if(!$link){
echo “I am sorry, but you were not able to connect to the MySQL server using”;
echo '
Host = ' . $host;
echo '
Db User = ' . $dbuser;
echo '
Db Pwd = ' . $dbpassword;
echo '
DB Name = ' . $dbname;
echo '
';
echo “This is what mysql says about the error
“;
die(mysql_error());
}
mysql_select_db(“$dbname”,$link) or die (“could not open db $dbname n”.mysql_error());
echo “You have connected to the database $dbname which says mysql is working”;
}
?>

The values above (e.g., $host, $dbuser) are the values that I'm entering into Connect to MySQL Host in SQLyog. Is SQLyog expecting something else?

– B.

[peterlaursen]

You may have different usernames (for the account as such, for FTP and more). Are you sure you use the right one?

[Brian Lovett]

peterlaursen wrote on Jul 1 2009, 02:01 PM:

You may have different usernames (for the account as such, for FTP and more). Are you sure you use the right one?

I thought that might be the issue, so I tried all of the usernames and passwords I had. Nothing is working. Having said that, the error does say “Unknown MySQL server host '[username].powwebmysql.com' (11004),” so I'm assuming that this is specifically related to the host name rather than a wrong database username or password. Any other thoughts? Thanx for responding.

– B.

[peterlaursen]

Yes .. you are right – it is not authentication that is a problem. It is a DNS/routing problem.

If you have a webserver locally with PHP + mysql extensions you can test that PHP script yourself. This is actually the only way I think. I think they overlooked something but trying the PHP script from your machine will tell.

If you are not familiar with setting up such software stack you can let us try. However, we will need your details of course. You may crate a support ticket for privacy.

[Brian Lovett]

peterlaursen wrote on Jul 2 2009, 02:40 AM:

Yes .. you are right – it is not authentication that is a problem. It is a DNS/routing problem.

If you have a webserver locally with PHP + mysql extensions you can test that PHP script yourself. This is actually the only way I think. I think they overlooked something but trying the PHP script from your machine will tell.

If you are not familiar with setting up such software stack you can let us try. However, we will need your details of course. You may crate a support ticket for privacy.

Again, thanx for the response. I'd be happy to setup a ticket and let you try as I'd really like to see what Webyog does and I think Webyog would help me. I spent a few hours trying to figure this out and I'm spent. I searched for a link to setup a ticket but can't find it – where can I do this?

– B.

[peterlaursen]

http://www.webyog.com .. about us .. contact or directly here: http://www.webyog.com/support/ttx.cgi

[Brian Lovett]

peterlaursen wrote on Jul 2 2009, 10:35 AM:

http://www.webyog.com .. about us .. contact or directly here: http://www.webyog.com/support/ttx.cgi

Done – ticket number #7567.

– B.

[Brian Lovett]

(Sigh.)

Peter, thanx for all of your help and responding as quickly as you did. I just spoke with tech support after getting ignored the whole day and spoke to someone who actually knew what they were talking about. The answer is Powweb doesn't allow you to remote in. GGGrrrrrrrrrrrrr.

I guess I now know why I'm only paying $100 for 2 years of hosting.

Anyone know of a good business hosting provider that allows you to remote in and charges $50/year? 🙂 I've got 28 days left to find myself a new hoster so I can use your (what looks like) great software.

– B.

[Author]

Posts