How to Install phpMyAdmin Tool and Add Databases to It

From this tutorial you’ll learn how to install phpMyAdmin tool and add databases to it.

Installing PhpMyAdmin Tool

1. First, let’s download phpMyAdmin. You can do it from the official phpMyAdmin website.
2. Unzip the archive using any archive program that is convenient for you (e.g., WinZip, StuffIt, etc.).
3. Upload the folder with all the unzipped files to your server using FTP file manager (e.g., Total Commander, FileZilla, etc.).
4. Create config folder in the phpMyAdmin directory. Check the folder attributes to allow the server to write and read it.
5. Navigate to your browser and input http://your_host.com/path_to_phpMyAdmin/setup/ URL link in the address bar and click on New Server button in order to add a new server.
6. Input your new server host name in the Server Hostname field. You need to contact your hosting provider in order to get the hostname to connect it to your database.
7. Click on Authentication tab in the top. Here select the authentication type you want to use.
8. Leave User for config auth blank.
9. Type in the message to display when login to phpMyAdmin in the HTTP Realm field.
10. Save the changes.
11. Click on Save on the Overview page in order to save the config.inc.php file. You need to move it to the main phpMyAdmin directory.
12. Now let’s delete the config folder and rename the setup directory.
13. Return to your browser and input http://your_host.com/path_to_phpMyAdmin URL address into the address bar. Note, that the address URL is a sample, and you need to paste your actual hosting and the path to phpMyAdmin folder there.
14. As a result, you’ll be able to log in to phpMyAdmin tool. Enter your username and password and navigate to your databases in order to start working with them.

Displaying Single Database with phpMyAdmin

1. To display a single database using phpMyAdmin you’ll need to create the config folder in the root phpMyAdmin folder.
2. Now open your browser and fill in http://your_host.com/path_to_phpMyAdmin/setup/ URL address in the address bar.
3. Click on Edit button and navigate to server configuration tab.
4. Here you can fill in the database name you want to display in phpMyAdmin. Then save the changes.
5. Return to your file manager tool and move config.inc.php file from config directory to the main phpMyAdmin folder.
6. Access phpMyAdmin tool from your browser. As a result, you’ll see the database you’ve specified in the list of databases.