Installing PHPMyAdmin on your AccountWritten by Tim Sisson
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
- 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/
- 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).
- Once in File Manager, upload the package you downloaded to the public_html folder.
- 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.
- 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"
- Rename the folder "phpMyAdmin-126.96.36.199-all-languages" to "phpmyadmin"
- Visit the folder in your web browser http://yourdomain.com/myphpadmin/setup
- You will need to create a config.inc.php file, however the setup page will walk you through that process.
- 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"
- This will create a config.inc.php file in your config folder you created. Now, move the file to the main folder "/phpmyadmin"
- Delete the folder "config" for security purposes.
- 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
- Open the SSH connection and type the following command:
- Next get the compressed file to install with this command:
- Unzip the compressed file using the following command:
- Assign the correct file permissions using :
chown -R $USER:$USER phpMyAdmin-188.8.131.52-all-languages*
- Move the files to the appropriate place:
- Copy the file and rename the config.inc.php file:
- 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
- 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.
unzip phpMyAdmin-184.108.40.206-all-languages.zip > /dev/null
mv phpMyAdmin-220.127.116.11-all-languages phpmyadmin
cp -p config.sample.inc.php config.inc.php