Q. How to access the database without its cPanel credentials?

This article will help you to access databases of cPanel users’ without accessing the cPanel account.

Consider the scenario, you’ve a cPanel account and you want to share the details of a database (DB) with one of your we site developers and  actually you do not want to share the cPanel credentials.

In normal cases, to access the PhpMyAdmin you need the cPanel login credentials. In this post Cr a solution for that problem. You can use the PhpMyAdmin package to access databases separately without knowing the account’s password

In cPanel, the default location for phpMyAdmin is:

https://yourdomain.com:2083/3rdparty/phpMyAdmin/index.php

This main user will have the privilege to access all the databases created under the cPanel account. In this topic, you will find out the way to grant MySQL database access outside the cPanel login.

Download its latest version!

Phymyadmin Latest version – Download

1. Download the stable version of PhyMyAdmin  (phpMyAdmin-4.x.x-english.tar.gz)

2. Upload the the tar file (ex: phpMyAdmin-4.x.x-english.tar.gz) into public folder of the shared account and extract it.

3. Rename the folder so that you can access it by an easy-to-remember URL.

The default URL should be look like:

http://yourdomain.com/phpMyAdmin-4.x.x-english

Rename it to an easy link:

http://yourdomain.com/phpMyAdmin

How to test?

Create a MySQL database and a database user.

You can create MySQL database and user for it from cPanel itself, under MySQL databases section.

1

I created crybit_phpMyAdmin db and crybit_phpAdmin user for testing purpose.

Access the PhyMyAdmin panel from your web browser

http://yourdomain.com/phpMyAdmin

Now you can use the MySQL username (Eg. crybit_phpAdmin) and password to the access the assigned database (Eg. crybit_phpAdmin).

phpmyadmin-2

You will get a login prompt like the image below:

Once login success, you can manage the database like you deal via cPanel default PhpMyAdmin. Try it and let me know if you face any trouble.

That’s it! Thank you!

Related Links:
cPanel icon is missing from WHM’s List accounts option.
How to find the total number of connections for a cPanel domain from the log files.
cPanel is showing invalid login.