Install PHPMyAdmin panel using FTP

This tutorial will show you how to install PHP MyAmin panel using FTP.
This will be useful in case when you do not have remote connection to a database, your hosting provider do not have installed PHP MyAdmin, or when you are not so familiar with your database server and want to manage it with friendly user interface.

The installation is rather easy, but you may have issues if you haven’t done that ever.

First download the latest version of PHP MyAdmin from their official website: www.phpmyadmin.net

Install PHPMyAdmin panel using FTP

Download phpMyAdmin.x.x.x-language.zip one (the one with extension ‘.zip’) ‘“ this will be easy to extract even if you do not have dedicated software on your computer for archives.

Extract all the files to a folder on your local computer and then using FileZilla to upload transfer all the files and folders on your hosting server in a folder created for PHP MyAdmin files. I called mine PMA:

Install PHPMyAdmin panel using FTP

Now it is rather not so logical, but in order to have phpMyAdmin configured with script instead of editing files on the server trough SSH ‘“ you should go and create one ‘config’ folder.

Install PHPMyAdmin panel using FTP

The previous picture shows how to do that using FileZilla. Now we must locate a file called ‘config.sample.inc.php’ on our local computer. Then rename it to ‘config.inc.php’ and upload it into the newly created folder.

When the transfer is finished right click on the ‘config’ folder and give 755 permissions.

Install PHPMyAdmin panel using FTP

Apply to all files and directories. This is important for the PHPMyAdmin installation.

Now go to this URL: http://www.your-domain.com/PMA/setup – where www.your-domain.com will be your hosting server address or domain name.

Install PHPMyAdmin panel using FTP

Now click on ‘NEW SERVER’ inside the phpMyAdmin setup to setting up your database server.

I will not continue further since all of the next steps depend on the configuration and the permissions of your database server and this information can be gathered from your hosting provider or from your server specification.
There are little icons like question marks with self explainable pop-ups for every field.

If all the settings are correct when you go to http://www.your-domain.com/PMA/
You should see the phpMyAdmin login screen:

Install PHPMyAdmin panel using FTP

Tags

Filed Under: phpMyAdmin

Anthony Gee About the Author: Anthony G. is an IT specialist with more than 9 years of solid working experience in the Web Hosting industry. Currently works as server support administrator, involved in consultative discussions about Web Hosting and server administration. One of the first writers in the Onlinehowto.net website, now writing for Free Tutorials community - he is publishing tutorials and articles for the wide public, as well as specific technical solutions.

Comments (9)

  1. Bilal says:

    I having trouble accessing my database on web server. It run great on local server (Wamp Server) PHP-Mysql but when I try to login in web server it says no database selected.

  2. Tonny says:

    Bilal, are you sure that PHPMyAdmin is configured correctly on the server?

    Post your error or screenshoot.

  3. Dale says:

    Thanks for the helpful tutorial!

  4. sohrab says:

    hi
    this was really great!!! thanks a lot
    do you know any way to install our own version of php too??
    this will be absolutely great!!!
    thanks

  5. sohrab says:

    suppose that i have created my own phpmyadmin panel, how could I create a Mysql user in there? is it possible? usually i do it through cpanel

  6. chaido says:

    The site I neew to make is going to be uploaded in a subfolder of a domain. After doing everything in thw above list I get the following message.

    You do not have permission to view this directory or page using the credentials that you supplied.

  7. murk says:

    In my case the config directory required all the file attribute options enabled (777) before setup was happy. That was with version 4.0.8 of phpmyadmin.

Leave a Reply