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.

Note! PhpMyAdmin can also be installed through Softaculous in your Control Panel.

Installing PHPMyAdmin on Shared Hosting Packages

  1. You will first need to visit the link below and download the zip file to install PHPMyAdmin. Choose the option to download the latest version.  http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/
  2. php_1
  3. Once you have downloaded the zip file, you will need to upload the file via an FTP program or cPanel using File Manager. (If you do not have an FTP client, we recommend using FileZilla a free FTP client).
  4. Once in File Manager, upload the package you downloaded to the public_html folder.
    php_2
  5. After you have successfully uploaded the file you will need to uncompress it. To uncompress the file, right-click the highlighted file and select extract.
  6. php_3
  7. Once the file is extracted, you will notice there is a file folder created. You now need to create a folder in the new folder called "config"
  8. Rename the folder "phpMyAdmin-3.4.3.2-all-languages" to "phpmyadmin"
  9. Visit the folder in your web browser http://yourdomain.com/phpmyadmin/setup 
  10. You will need to create a config.inc.php file, however the setup page will walk you through that process.
    php_4
  11. Click "new server" and in the field "Verbose name of this server" enter a name of your server so you can identify it. Then click "Save"
  12. This will create a config.inc.php file in your config folder you created. Now, move the file to the main folder "/phpmyadmin"
  13. Delete the folder "config" for security purposes.
  14. Now, you can access PHPMyAdmin without accessing cPanel by visiting: http://yourdomain.com/phpmyadmin/index.php

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

*** Please Note: If using SuPHP, then you have to make sure that .htaccess files do not have PHP settings.

Installing PHPMyAdmin using SSH

  1. Open the SSH connection and type the following command:
  2. cd ~$USER/public_html

  3. Next get the compressed file to install with this command:

    Wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.3.2/phpMyAdmin-3.4.3.2-all-languages.zip?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphpmyadmin%2Ffiles%2FphpMyAdmin%2F&ts=1311619171&use_mirror=surfnet">

  4. Unzip the compressed file using the following command:
  5. unzip phpMyAdmin-3.4.3.2-all-languages.zip > /dev/null

     

  6. Assign the correct file permissions using :

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

  7. Move the files to the appropriate place:
  8. mv phpMyAdmin-3.4.3.2-all-languages phpmyadmin

     

  9. Copy the file and rename the config.inc.php file:
  10. cp -p config.sample.inc.php config.inc.php

  11. You need to set a random string to the “blowfish_secret”. To do so use this command:

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

  12. You can now access PHPMyAdmin by visiting: http://yourdomain.com/phpmyadmin/install

    Please remember to replace “your-domain.com” with your actual domain name.

    *** Please Note: If using SuPHP, then have to make sure that .htaccess files do not have PHP settings.

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!

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!
Ask a Question
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?
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.
n/a Points
2014-04-11 4:46 am

Is this alowed on all hosting plan?

Staff
10,994 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-05-21 8:12 am

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

Staff
9,942 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 !

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?

 

Staff
18,399 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.

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.

9 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!