How can I Access All the Database in Dedicated Server ?

Error: 

#2006 MySQL server has gone away

Solution :

1. If you are trying to run a big mysql query or else you are trying to import or export the huge database from your end which is highly resource intensive.
2. If you are using a heavy loop or uses mulitple join,union in your query coding.
3. If you are trying to ALTER all the rows in a data intensive table.

To avoid this import the database part by part this should allow you to generate data without any issues.

Error :

Access Denied

Solution:

The error “Access denied for user” might be due to the wrong database username,password or database name. Also check with the following sample database connection string as,

[ Sample Database Connection String ]

$dbh=mysql_connect (“localhost”, “cpuser_dbuser–> this is database username”,
” –>this is databaseuser password”) or die(‘Cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (“cpuser_dbname–>this is database name”);

Error :

Mysql Server Gone Away

Solution :

This could happen due to 2 possibilities

1. Poorly optimized php scripts which takes a lot of time to execute and hence mysql quits processing
2. If there are too many mysql connections opened from your website which makes mysql to quit

Also make sure that you are closing mysql connection after you open and use a connection. This could also be a reason.

If you feel that your usage is genuine and your website is well optimized and such a usage is required, then please upgrade that particular account alone  to Higher Package