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:
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
Step 1. Download the stable version of PhyMyAdmin (phpMyAdmin-4.x.x-english.tar.gz)
Step 2. Upload the the tar file (ex: phpMyAdmin-4.x.x-english.tar.gz) into public folder of the shared account and extract it.
Step 3. Rename the folder so that you can access it by an easy-to-remember URL.
The default URL should be look like:
Rename it to an easy link:
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.
I created crybit_phpMyAdmin db and crybit_phpAdmin user for testing purpose.
Access the PhyMyAdmin panel from your web browser
Now you can use the MySQL username (Eg. crybit_phpAdmin) and password to the access the assigned database (Eg. crybit_phpAdmin).
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!
- 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
What are the modern methodologies to build a perfect monitoring setup?
Yeah, the SRE signals. Mainly there are three modern methodologies available in building a perfect dashboard.
1, USE method by Brendan Gregg.
2, RED method by Tom Wilkie.
3, LTES method from Google SRE book.READ MORE : https://www.crybit.com/modern-monitoring-concepts-an-intro-to-prometheus-world/