MySQL Error

[pvivekk]

Hello Support,

I have recently installed opencart for my domain http://poduvalvivek.x10hosting.com/cart/ but I am getting the following error while accessing this URL.
~~~
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/pvivekk/public_html/cart/system/database/mysql.php on line 6
Error: Could not make a database connection using pvivekk_opencart@mysql.x10hosting.com
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/pvivekk/public_html/cart/system/database/mysql.php on line 65
~~~

Please check and resolve it.

Thank you.

Regards,
Vivek

 

[gomarc]

Are you using

Database host: "localhost"
Database Name: "pvivekk_opencart" ?

If so, you may want to go to cPanel -> phpMyAdmin and make sure the database is there.

 

[pvivekk]

Hello,

Yes, it is present there. You could have verified this from the backend.
~~
// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'mysql.x10hosting.com');
define('DB_USERNAME', 'pvivekk_opencart');
define('DB_PASSWORD', 'ax0or9lxqs');
define('DB_DATABASE', 'pvivekk_opencart');
define('DB_PREFIX', 'oc_');
~~

Please try to reset the password. That should fix the issue.

Thank you.

Regards,
Vivek
Edit:
Hello,

I tried changing the HOSTNAME to localhost, but still the problem persist.

Regards,
Vivek
Edit:
Hello,

I tried changing the HOSTNAME to localhost but still the problem persists.

Regards,
Vivek

 

[gomarc]

Yes, it would be nice if I had backend access, but I don’t. I’m just another user like you!

Are you sure that the database exists? Have you created the database prior to the installation of the shopping cart?


Note aside, if you posted the real password, you may want to change that right away!

 

[pvivekk]

Hello,

Please do not reply to this thread except the support team.
I have installed the cart using Softaculous, so there is no doubt about the database creation. Also I know cPanel well.
So I expect all to be more familiar with the system we use. As a Linux administrator, I know what could be the fix for a particular error.
Well regarding password, you said a valuable point.

Regards,
Vivek
Edit:
Hello Support,

Also I tested the database connection and is working fine.
URL : http://poduvalvivek.x10hosting.com/cart/system/database/databasetest.php

This is one thread I got from google.
http://forums.mysql.com/read.php?52,151255,213970#msg-213970


Regards,
Vivek
Edit:
Hello Support,

Also I tested the database connection and is working fine.
URL : http://poduvalvivek.x10hosting.com/cart/system/database/databasetest.php

This is one thread I got from google.
http://forums.mysql.com/read.php?52,151255,213970#msg-213970


Regards,
Vivek