At Web Hosting Hub, phpMyAdmin is included on all hosting accounts.  To access phpMyAdmin, first you must log into your account cPanel. There may be times however that you need a developer to access your databases.  If you don't want to give your developer access to the cPanel, you can install PHPMyAdmin.  This will allow you to give your developer direct access to phpmyadmin without logging into cPanel.

Installing phpMyAdmin

  1. Visit this site and download the latest version of phpMyAdmin:

    http://sourceforge.net/projects/phpmyadmin/files/

    phpadmin1

  2. Once you download the zip file, upload the zip file into your public_html folder.  You can do this via FTP, however in this example we will use the cPanel File Manager:

    phpadmin2

  3. Once the file is uploaded, extract the file. To extract the file, click the zip file and select Extract:

    phpadmin3.1

  4. Make sure the zip file is extracted into the public_html folder:

    phpadmin4

  5. You now need to create a folder in phpMyAdmin-3.4.2.2-all-langages folder. Open the folder that was just created by the unzipped file:

    phpadmin5

  6. Next click on New Folder in the menu:

    phpadmin-createfolder

  7. Name the new folder you are creating “config”:

    phpadmin7

  8. Now go back to your public_html folder.  Next we will rename the phpMyAdmin-3.4.3.2-all-languages folder to just phpmyadmin.  We do this to make the link to access your phpmyadmin easier to remember.  To rename the folder, first right-click on phpMyAdmin-3.4.3.2-all-languages and select "Rename":

    phpadmin8

  9. In the box, put in the new name as phpmyadmin and click OK:

    phpadmin9

  10. Next we will set up phpMyAdmin. Visit http://yourdomain.com/phpmyadmin/setup in your web browser (replacing yourdomain.com with your domain name). The following page will appear:

    phpadmin10

  11. You will need to create a config.inc.php file. This setup page will create the file for you. Click New server as highlighted above.  In the field labeled “Verbose name of this server” enter a name for your server.  In this example we will just call it "Hub Server".  Once you have put in your server name, click Save:

    phpadmin11

  12. Confirm your server name is added and click Save again:

    phpadmin12

  13. Now we will go back to your cPanel File Manager.  In the "config" folder that we created earlier, now there is a file called config.inc.php:

    phpadmin13

  14. We need to move the file into the phpmyadmin folder. Right-click on the config.inc.php and select "Move." Move the file to the phpmyadmin folder:

    phpadmin14

  15. We are almost done.  So that no one else can configure your settings, once the file's moved delete the config folder:

    phpadmin15

  16. Finally we are ready to access your phpmyadmin.  In your browser, visit http://yourdomain.com/phpmyadmin/index.php (replacing yourdomain.com with your primary domain):

    phpadmin16

  17. Now you can log directly into your phpmyadmin without accessing the cPanel.  For the username and password, just use the username and password for one of your databases.  To find the user assigned to your database, login to your cPanel and access the MySQL Databases section:

    phpmyadminuser

  18. Once you have confirmed your username, you can log into phpmyadmin:

    phpadmin17

    If you've forgotten your database password, check your database software for the best method to retrieve it.


  19. Congratulations, now you know how to install phpMyAdmin in your cPanel account.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Comments

n/a Points
2015-02-18 3:34 pm

Hi i followed the steps but i cn't seem to log in to pypmyadmin. i put in the username and password from my cpanel but i can't log in. any suggestions 

Staff
12,339 Points
2015-02-19 8:17 pm
Hello N_Thirty,

Thank you for your question. Your cPanel credentials will not allow you to access your databases.

Instead, you must Create a Database User, and Assign a User to a Database.

You will then be able to login to your database using the user you just created.

Thank you,
John-Paul
n/a Points
2015-07-11 9:04 pm

I've complete all steps and write http://woh.hol.es/phpmyadmin/index.php but no any page open. Kindly help me via mail. 

Staff
16,266 Points
2015-07-13 8:26 pm
Hello zohaib,

When I visit the link I get the phpMyAdmin login page. Were you able to fix the error yourself or are you still seeing an error?

Kindest Regards,
Scott M
n/a Points
2016-04-28 3:44 pm

Thankyou so much. Its working properly

n/a Points
2016-10-07 9:26 pm

WHat should be there in the server name field.I'm not able to access my database directly please help.

 

Staff
12,339 Points
2016-10-07 10:03 pm
Typically, it would be 'localhost' unless you are connecting remotely, then it will be the domain name.

Thank you,
John-Paul
n/a Points
2018-10-05 3:07 pm

Hi,

Thanks for this tutorial.

I followed all your steps and successfully installed phpmyadmin but i got following error.

phpMyAdmin - Error

Invalid authentication method set in configuration: cookie

Please suggest some solution so i can access my phpmyadmin.

Staff
536 Points
2018-10-05 5:12 pm
Please ensure you don't have any extra spaces before and after that word in the config file.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.
}