InMotion Hosting Support Center

If you have a web designer and they are designing your website with a content management system (CMS), the designer may need access to the databases. Until now, the easiest solution was to provide them with the cPanel username and password to access phpMyAdmin. For security purposes, this may not be the best solution since this would allow the third party complete access to your cPanel account, including email, add-on domains, and other files/ databases you may have.

You can install phpMyAdmin on your account in a few easy steps that will eliminate the need to provide your designer with cPanel access.

Installing phpMyAdmin on Shared Hosting Packages

  1. Download the zip file of the latest version at phpMyAdmin.net.
    phpmyadmin.net website
    You can read about verifying file checksums in our related article.
  2. Once you download the zip file, you'll need to upload the file via an FTP program or cPanel using File Manager. We recommend FileZilla for FTP.
  3. Once in File Manager, upload the package you downloaded to the public_html folder.
    zip file in cPanel File Manager
  4. After uploading the file, uncompress it. To do so, right-click the highlighted file and select extract.
    Extracting file in File Manager
  5. Once the file is extracted, you will notice there is a file folder created. Rename the folder "phpMyAdmin-4.8.3-all-languages.zip" to "phpmyadmin" or similar for additional security.
  6. Visit the folder in your web browser, e.g. http://example.com/phpmyadmin/setup.
  7. You will need to create a config.inc.php file. You can do this on the setup screen, download the file, and upload it into the /phpmyadmin directory or by copying public_html/phpmyadmin/config.sample.inc.php to config.inc.php.
    phpMyAdmin setup screen

    Note: Info on all options possible in the config file such as Authentication options is available in phpMyAdmin documentation.

  8. Click New server and type your server hostname beside "Verbose name of this server", easily found in your AMP Account Technical Details. Then click "Save".
  9. You can now access phpMyAdmin without cPanel by visiting, e.g. http://example.com/phpmyadmin/index.php.
  10. Note: If using SuPHP, make sure the .htaccess files do not have PHP settings.

Congratulations! You have successfully installed phpMyAdmin externally and you can access your databases without cPanel!

Installing phpMyAdmin using SSH

  1. SSH into the cPanel account.
  2. Enter the public_html folder:

    cd ~/public_html

  3. Install the compressed file:

    wget https://files.phpmyadmin.net/phpMyAdmin/4.8.3/phpMyAdmin-4.8.3-all-languages.zip

  4. Unzip the compressed file:

    unzip phpMyAdmin-4.8.3-all-languages.zip > /dev/null

  5. Assign the correct file permissions:

    chown -R $USER:$USER phpMyAdmin-4.8.3-all-languages*

  6. Move the files to the appropriate place:

    mv phpMyAdmin-4.8.3-all-languages phpmyadmin

  7. Copy the file and rename the config.inc.php file:

    cp -p phpmyadmin/config.sample.inc.php phpmyadmin/config.inc.php

  8. Set a random string to the “blowfish_secret”:

    randomString=$( head -1 /dev/urandom|md5sum|cut -d" " -f1 ); sed -i "s/\$cfg\['blowfish_secret'\] = '';/\$cfg\['blowfish_secret'\] = '$randomString';/g" config.inc.php; unset randomString

You can now access phpMyAdmin by visiting, for example, http://example.com/phpmyadmin/install.

Note: If using SuPHP, make sure the .htaccess files do not have PHP settings.

Install phpMyAdmin in Softaculous

  1. Log into cPanel directly or via AMP.
  2. Search and select the 'Softaculous Apps Installer' icon in cPanelSoftaculous button.
  3. From the left of the page, search and select phpMyAdmin under DB Tools.
    Screenshot in Softaculous searching for and selecting phpMyAdmin
  4. Select Install Now to begin with installation details.
    Screenshot selecting 'Install Now' to begin with installation details
  5. Specify the protocol, domain, directory, database host, and Softaculous backup location as needed before pressing Install.
    Blue Softaculous install button

    Note: You'll receive the error below if the specified domain isn't using PHP 7.1 or higher. You can check this via cPanel PHP Configuration (or MultiPHP Manager for VPS/Dedicated)
    or a phpinfo page - e.g. example.com/phpinfo.php.
    Screenshot showing at least PHP 7.1 required to install phpMyAdmin
    Select the checkbox in the warning to update the specified domain (or subdomain) to PHP 7.1 or edit it manually from the cPanel PHP Configuration (MultiPHP Manager for VPS/Dedicated). Screenshot showing ability to check box to change PHP version to 7.1

Congratulations. You can now access phpMyAdmin using your specified domain.

Was this article helpful?

Related Questions

Here are a few questions related to this article that our customers have asked:
How can I upgrade phpMyAdmin?
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

n/a Points
2016-06-22 10:25 pm

I have a shared hosting site and installed phpadmin to a folder in my account, however what is the hostname I should set in phpadmin ?

Staff
42,232 Points
2016-06-22 10:54 pm
Hello Ricky,

Typically, the host name for a MySQL database using the database on our servers is set to "localhost".

If you have any further questions, please let us know.

Kindest regards,
Arnel C.
Staff
42,232 Points
2014-11-07 12:15 pm
Hello Oz,

Sorry you're having problems with the config folder. Unfortunately, it's difficult for us to determine what you've done in the process unless you have an account we can access. Can your provide a URL for the site? Also, can you describe how you are creating the new folder or directory? It would help us to understand why you say the folder is not being seen by phpMyAdmin. Are you able to see the contents of the folder?

Please provide a little more information and we would happy to help.

Regards,
Arnel C.
n/a Points
2014-11-07 7:31 am

 

I created a config folder but phpMyAdmin doesn't see it and say still create a folder whats the problem?

 

n/a Points
2014-05-21 8:12 am

where can we create/modify users to access the newly created phpmyadmin ?

Staff
11,186 Points
2014-05-21 8:58 am
The PHPMyAdmin wiki page on creating new users has excellent instructions on how to create those new users.
n/a Points
2014-05-21 9:15 am

the prob is that the "privileges" tab does not appear, i guess it's a root privilege thing..Thank you !

Staff
31,313 Points
2014-04-11 11:49 am
Hello dilan,

Thank you for your question. Yes, you can install PHPmyAdmin on any account, however it is in cPanel by default, in the Databases section.

If you need to install it, I recommend using Softaculous to install PHPmyAdmin, since it is a simplified 1-click installation.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul
n/a Points
2014-04-11 4:46 am

Is this alowed on all hosting plan?

2012-12-02 10:43 pm
Figured it out. :lol:

You want to update this article to reflect that for shared hosting environments you can just (re)install myPHPadmin directly to the domain of your choosing from the new applications module in cPanel.

Thanks

PS - It might be good to also instruct Wordpress users to install it in a new folder named "phpmyadmin" as you'll get an error if you try to install it in the same folder where a Wordpress installation exists. Some may accidentally choose overwrite files, which could be very problematic.
2012-12-02 10:26 pm
I keep getting a "Page Not Found Error" on step 7. Its like its looking for an actual webapge as opposed to prompting the installation script. Is there another way to initiate the installation?

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.

11 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!