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 DevOps Engineer, currently working in one of the best companies in India. I am having around 5 years of experience in Linux Server Administration and DevOps tools.
I love to work in Linux environment & love learning new things.
Powered by Facebook Comments
Leave a Reply