We all know what PHPMyAdmin is. Quoting from WikiPedia:-
Now, on a cPanel server we all know how to access PHPMyAdmin. Thats right, login to cPanel >> PHPMyAdmin to access the databases of the account or WHM >> PHPMyAdmin to access all databases if you have complete root access over the server.
Consider the case when you have a cPanel account and you want to share the details of a database with one of your developers or client and actually you do not want to share the cPanel credentials and just access to the database alone. In normal case, to access the PhpMyAdmin you need the cPanel login details which will give him complete access over the account which we want to avoid for security or private reasons. This is how you do that. You can use the PhpMyAdmin package to access databases separately without knowing the account password.
To achieve this, you will have to install PHPMyAdmin locally in your account and call the link relatieve to your website via the browser and then enter the database username/password to login. Follow the steps below to do that.
2) Now, upload the tar file to the public_html or directory of choice of the cPanel account and extract it.
3) Rename the folder so that you can access it by an easy-to-remember URL.
Assuming the tar file was uploaded to public_html directory and the extracted directory was renamed as phpmyadmin, PHPMyAdmin can be accessed by the link http://example.com/phpmyadmin (example.com is assumed as the main domain of your account here. Change it with your domain name)
Now you can test it by checking if entering the database username and password created via cPanel >> MySQL Databases logs the user fine.