Home > Help Center > Shared Hosting > Databases > Install phpMyAdmin in Your cPanel Hosting Account

Install phpMyAdmin in Your cPanel Hosting Account

When you read such a title, the first thought is - why install phpMyAdmin since I can access it in my cPanel?

Well, let's imagine you need to develop a new site in your hosting but you do not want to give access to your cPanel to the developers. The decision about website directory access seems easy - create a new FTP account, but what about MySQL database access?

The correct answer is: we are going to create a new database with privileged user and password and we are going to install phpMyAdmin in our website's root directory, so the developers may access this database only.

Download phpMyAdmin

We can download phpMyAdmin from https://www.phpmyadmin.net/downloads/ and depending on how we are going to extract the archive, we can select the archive file type:

  • If you are going to use cPanel's File Manager the .zip the archive is the right one;
  • If you are going with an SSH installation you can download (via the wget tool) .tar.gz;

File Manager Installation

Download https://files.phpmyadmin.net/phpMyAdmin/4.7.4/phpMyAdmin-4.7.4-english.zip on your computer.

You can extract the archive and upload through FTP to the website root directory or you can upload and extract the .zip archive through File Manager.

Go to cPanel > Files > File Manager and navigate to the website root directory.

Upload the archive:

Upload the phpmyadmin archive

Select the archive and click Extract in the toolbar:

Extract the archive

New directory will appear - phpMyAdmin-4.7.4-english (if you do not see it click Reload). Rename this directory to any name - ours will be pma/:

Rename the direcotory

Enter pma/ directory and rename the file config.sample.inc.php to config.inc.php (just remove the .sample part):

Rename the config file

Now open the renamed file, find row 17 and add 32 character long secret passphrase:

$cfg['blowfish_secret'] = '7e16b5527c77ea58bac36dddda6f5b4f'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Click Save Changes and close the file.

SSH Installation

As you can expect ssh installation takes less than a minute, below you can see all needed commands:

wget https://files.phpmyadmin.net/phpMyAdmin/4.7.4/phpMyAdmin-4.7.4-english.tar.gz
tar xzf phpMyAdmin-4.7.4-english.tar.gz
mv phpMyAdmin-4.7.4-english/ pma/
cd pma
mv config.sample.inc.php config.inc.php
nano config.inc.php

Create New MySQL Database

Now create a new MySQL database, create new database user with strong password and grant that user all privileges in the database (check our article MySQL Database Wizard):

Database name - cpaneluser_pmaDB
Database user - cpaneluser_pmaUSR
Database password - RP[TG7{oiRGt

Append /pma/ to the website's URL and enter it in the browser:

http://hostpulse-addon.net/pma/:

Open phpmyadmin in browser

In the fields enter the database username and password and click Go:

Insert username and password to enter the database

Your developers can now access and manage only this MySQL database for the particular website.

Conclusion

We hope this information will be very useful if you encounter a similar situation when account privacy is required and at the same time access to the website directory is also necessary.

Still not finding what you're looking for?

Contact our support team with any additional questions or concerns.

Contact support