Access phpmyadmin Directly without cPanel Login

How to Access phpmyadmin Directly without cPanel Login

When a developer needs to work exclusively on a database or access phpmyadmin and sharing the hosting control panel’s login credentials will not be the right option. So, what other solution do you have?

That’s how this article was created when this exact issue was faced by one of our clients. Usually, you will access phpMyAdmin which requires cPanel login details. However, we will share with you an alternative method using the database credentials through which you can access phpMyAdmin that doesn’t require cPanel details for your developer or yourself.

How to Access PhpMyAdmin Dashboard Directly:

Process 1: Download and Set up.

Step 1: Download the phpMyAdmin Package from the Official PhpMyAdmin website.

Download package phpmyadmin

 

Step 2: Log in to your cPanel using login credentials for the website.

Step 3: Search “File Manager” in the cPanel and navigate to “public_html”.

File manager - phpmyadmin

 

Step 4: Click upload option which shows on top of the page to upload the file. Now upload the downloaded “phpMyAdmin Package” and extract the file (as shown in below image).

Extract the file - phpmyadmin

 

A folder will be created once you extract the file as shown below.

extract folder name - phpmyadmin

 

Step 5: Right click on the folder and select “Rename“. Now rename the folder so that you can access your website with an easy-to-remember URL. (Example: phpMyAdmin)

Rename for setting URL - phpmyadmin

 

Congratulations! You’re all set up. You can now access phpMyAdmin with the /URL you have set.

 

Process 2: Access phpMyAdmin Using Database Credentials.

Step 1: Open your browser -> Type your website name in search box and type /phpMyAdmin. (The name of the phpMyAdmin package in your root directory)

(Example – https://yourdomainname/phpMyAdmin) replace “yourdomainname” with your actual domain name.

 

Step 2: You can use your Database Login credentials to access phpMyAdmin dashboard directly as shown in the below example.

User Name: database_username

Password: database_password

Replace the username and password with your website database details.

Access phpmyadmin

 

Useful Resources:

What is MySQL– Things You Must Know!

How to Add a WordPress Admin User in phpMyAdmin

 

Hope this article helps you to access phpmyadmin using database details.