Access PhpMyAdmin without cPanel login

Hi,

Today I will show you how to access phpMyAdmin without accessing your control panel ( like cPanel, plesk ).

This is required when your developer works on Database only and you do not want to share the login credentials of your hosting control panel.

In normal cases to access  phpMyAdmin, you need the cPanel login credentials. In this post, I will show a way from which you can use the phpMyAdmin package to access databases separately without knowing the account’s login details.

As we know, 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 post, you will find out the way to grant MySQL database access outside the cPanel login.

>>Steps:

1. Download the stable version of PhyMyAdmin  from the offical site of phpMyAdmin.
2. Upload the tar file (ex: phpMyAdmin-4.x.x-english.tar.gz) into public folder (document root) of the your hosting 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

NOTE: Those who has access to the server, they can use the below command to do this:

1. Download the package:

wget https://files.phpmyadmin.net/phpMyAdmin/4.7.0/phpMyAdmin-4.7.0-english.tar.gz

2. Extract the package:

tar -xvzf phpMyAdmin-4.7.0-english.tar.gz

3. Change the ownership to user cPanel account name:

chown -R username:username phpMyAdmin-4.7.0-english/

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

mv phpMyAdmin-4.7.0-english phpMyAdmin

>>Testing:

1. Create a MySQL database and a database user.

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

https://documentation.cpanel.net/display/ALD/MySQL+Databases

2. Access the PhyMyAdmin panel from your web browser.
http://yourdomain.com/phpMyAdmin

Now you can use the MySQL username and password to access the assigned database. You will get a login prompt like the image below:

If you have any doubt, feel free to let me know. I will be more than happy to help you.

Thank you. 🙂

My name is Shashank Shekhar. I am a Software Engineer, currently working in one of the leading web-hosting companies in India. I am having 2 years of experience in Linux Server Administration.

I love to work in Linux environment & love learning new things.

Powered by Facebook Comments

Be the first to comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.