Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Got a new host, but can't connect to database?


Learner1988

Recommended Posts

Hi.

 

Because of issues with our host we decided to get a new one.

 

As we moved the entire site, we got this error message:

 

 

 

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /web/www.XXXXX.dk/www/includes/functions/database.php on line 19

Unable to connect to database server!

 

Our configure.php info looks like this:

 

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'XXXXX');

define('DB_SERVER_PASSWORD', 'XXXXXXXXX');

define('DB_DATABASE', 'gleam_dk_db');

 

Username and password is correct!

 

Now we've tried:

"localhost"

"mysql1.wannafind.dk" - Which is listed as the database server in our info mail with from our host.

and "127.0.0.1"

 

Every single one gives us the above written error message.

 

We've contacted our host, but their response time is insanely slow.

 

So I was hoping you guys might have an idea or two?

Link to comment
Share on other sites

Hi.

 

Because of issues with our host we decided to get a new one.

You mean you wanted to get a new issue?

 

Did you create the database on the new db server and up loaded the sql?

Link to comment
Share on other sites

Yes, I can easily access it manually. And yes I've uploaded the SQL file. All the tabels seem to be there.

If you access it via phpmyadmin, there should be an indication at the top of the page eg

Server: localhost Database: databasename

 

and you can also confirm that the username and password are correct and the user name has full priviledges.

Link to comment
Share on other sites

If you access it via phpmyadmin, there should be an indication at the top of the page eg

Server: localhost Database: databasename

 

and you can also confirm that the username and password are correct and the user name has full priviledges.

 

 

Thanks.

 

Localhost and the database is correct aswell.

I logged on succesfully. Which has to mean that password and username is correct right?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...