In this tutorial, I will explain how you can install PHPMyAdmin on a webserver via FTP using FileZilla or your favorite FTP application. This tutorial assume you are using FileZilla and I am installing a secondary PHPMyAdmin on a Hostgator shared server. The instructions will be the same if you are installing a primary installation of PHPMyadmin, but it is worth knowing that if you already have a Cpanel with PHPMyAdmin access, you can still add another installation of PHPMyAdmin in a domain’s root folder for use with that domain name in case you may not have Cpanel access or maybe to give a developer simple access to Mysql.
What you’ll need
- FileZilla – if you don’t have an FTP client, Google FileZilla and install it before you start.
- Recent download of PhpMyAdmin – this can be found at http://www.phpmyadmin.net/home_page/downloads.php
- A web server or hosting account such as Hostgator, Godaddy or Amazon Ec2. I have installed PHPMyAdmin on all of these.
- A simple text editor such as notepad or notepad++.
- After downloading from he link above, unzip the phpMyAdmin folder on your desktop, open the unzipped folder and rename the sub-folder named “phpMyAdmin-4.2.8-english” to simply “phpmyadmin” for easier access later. Be sure that you rename the folder inside of the main folder, not the top level folder.
- Upload the phpmyadmin folder to your server in the web root directory for your domain name using FileZilla.
- After the files have all uploaded, using FileZilla, open the phpmyadmin folder and create a new directory named “config” inside of phpmyadmin. Give the folder writable permissions. To change permissions right click on the config folder and select to change file permissions and set them to 777 for now. You can tighten security later when your done setting it up.
- Open your web browser and navigate to http://example.com/phpmyadmin/setup/, but change example.com to your domain name and follow the instructions on screen. Go to next step or read on for alternative manual config method. If you want to configure manually instead, In the phpmyadmin folder on your desktop, look for the file named “config.sample.inc” and open it in a text editor such as notepad or notepad++. You can edit it by hand and upload to config(but I haven’t tested this recently)
- While still on the page you landed on at example.com/setup, scroll down to where you see the “New Server” button and click it to set up your server. If you don’t know what to do here, the best advice I can give you is to simply leave it be and select only an authentication method such as “http” and click “Apply” to have your server set up with defaults. I think the auth method is the most important setting to get you going quickly. If you use http auth method, you will simply need the user and password of an existing database to access it. If you don’t have that, use one of the other auth methods. If you don’t understand auth methods, click on the question mark next to each in the setup server dialog to read the documentation on it.
- After setting up your server, go to example.com/phpmyadmin and login and you should now see the database you logged into. If not, go back and edit your server settings until you get it to work.
doing a secondary install separate from Cpanel can be handy to access a single database for a single website, but if you do have Cpanel user and password, you can actually access all databases. Also, using Cpanel user and password, you can create new databases!
That’s it, I got lucky and mine worked with just setting the authentication type to http and using an existing mysql database user and password to access phpmyadmin, but if you didn’t have such good luck, refer to the phpMyAdmin documentation linked to in several locations in the setup area.
I did note the secondary phpMyAdmin installation ran slower than normal, but it did work. I think next time I will try an older version of phpMyadmin just to see if it is faster. Good Luck!