Access PhpMyAdmin without cPanel login

Apr 6 • All • 608 Views • No Comments on Access PhpMyAdmin without cPanel login

We all know what PHPMyAdmin is. Quoting from WikiPedia:-

 

 phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDB with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

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.

 

1) The latest version of PHPMyAdmin can be downloaded HERE The package should look something like  phpMyAdmin-4.x.x-english.tar.gz


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.

 

 

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

« »