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.

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.

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 our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
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!

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.