How can I Access All the Database in Dedicated Server ?

Dedicated Server allows you to access all the database in one interface. From there itself you can able to do all the actions in the databases.


Share This Now: [addtoany]

Watch Reseller Hosting Video Tutorial



Procedure

Accessing all the Databases In Dedicated Server

To Access all the database in Dedicated Server via WHM, please follow the below steps,

1. Login to the Dedicated Server WHM as root user.

2. Go to the path,

Home » SQL Services » phpMyAdmin

3. Once you click the phpMyAdmin , it will automatically redirect to the phpMyAdmin page where you can able to see all the database in the server.

4. From here you can click the database which you want to access . When accessing this you should be more careful. What are all the actions you are doing here it can’t be revert back.

Screen Shots

Refer Screen Shots

Troubleshooting FAQs

Dedicated Server WHM Troubleshooting FAQs

Getting error ” #2006 MySQL server has gone away “

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.

Getting Access Denied error in database connection

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”);

 

 

In Database Connection Facing Mysql Server Gone Away error

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

Downloads

Related Downloads

Related Articles