phpMyAdmin – Wingdings Translator Online

PHP application to manage MySQL or MariaDB databases through a graphical interface on a web page. We explain what PhpMyAdmin offers you and how you can install it.

phpMyAdmin is a completely free open source program. It is developed in PHP, so you can always make it work through a web server that supports this programming language. Like other free software, PhpMyAdmin is created by a community of developers who work on the project for the love of art. It is a very complete tool that allows access to all the typical functions of the MySQL or MariaDB database through a very intuitive web interface.

What is PhpMyAdmin?

When you develop applications based on databases, you often have to observe the state of the data in the tables, eventually modify some of this data, create tables, empty them, make backup copies and much more. You could do all this through the console, using the MySQL client, but for speed it is convenient to have a graphical interface program that gives you access to all these operations at the click of a button. That is basically what PhpMyAdmin offers you.

There are many MySQL clients through a graphical interface, which are also used to manage a database, such as , which are developed as a desktop application. The difference with PhpMyAdmin is that it is implemented through a web application. This means that you can have it installed on your computer to access your local databases, but you could also install it on a server to access the databases of that server, being able to manage the databases of that server through a browser, remotely and from any computer where you are.

The application itself is nothing more than a set of files written in PHP that we can copy to a directory on our web server, so that when we access those files, they show us some pages where we can find the databases to which they are connected. we have access to our database server and all its tables.

phpMyAdmin Page

The project home page is . From there we can download the files of the latest version of the application, which we must later place on our web server. We can also .

There are several versions available, but it is advisable to choose the one that is advised as the latest stable version (The last stable version). At the time of writing this article it was 2.2.6. And when updating it we are already at 5.1.1. So, if our system is Windows, we will download the file phpMyAdmin-2.2.6-php.zip

The project is very mature and surely the readers have heard of this system. In fact it works since version 3 of PHP. We are currently going for 8! so it has decades of active development.

Installing phpMyAdmin

Once the latest version has been downloaded, we have to unzip it, with which we will obtain the PHP files that make up the tool and place them inside the publication directory of our web server.

Note: Remember that phpMyAdmin is a project written in PHP, so we will need to put the files on a web server that allows programming PHP pages.

In addition, we must access the tool through the web server address, followed by the directory in which we have the files that we have unzipped. For example, if on our server we have placed the files inside the publishing directory (usually “htdocs”, “httpdocs” or “html”), in the phpMyAdmin subdirectory, we should write something like http://localhost/phpMyAdmin. But this already depends on how you have and what server program you are using.

If we had an Apache server installed, we would place them in the folder that we have indicated as “documentRoot”, which is usually htdocs.

The first thing we can read is the documentation file, which we find together with the phpMyAdmin files. It explains general information about the program, such as its requirements, installation instructions, configuration, frequently asked questions, etc.

Later, as the documentation explains, you have to edit the config.inc.php file to change the host values of the database (computer that has MySQL installed) and the username and password with which we connect. Many aspects can be configured in the tool, although now I will only comment on those that I have found essential to make it work. In the documentation we have a section completely dedicated to specifying the meaning of each variable.

$cfgPmaAbsoluteUri

We must assign it to the full path needed to access phpMyAdmin. It could be something like http://localhost/phpMyAdmin or http://www.mydomain.com/phpMyAdmin

$cfgServers string

The database host name. For example localhost, if it is the same computer where we are installing phpMyAdmin and the database. It could also be the IP address of the computer to which we connect.

$cfgServers string

$cfgServers string

The username/password pair that phpMyAdmin should use to connect to the MySQL server.

With these simple configurations we can now access phpMyAdmin and work with our database at the click of a mouse, which is very welcome considering that, if we do not have this tool or another similar one, the other option would be to use the language SQL, and, in case the database is hosted remotely on the Internet, we could not do it without TELNET access to the database server.

Note: In you can learn more about PHP and MySQL.

In the , you will be able to learn a lot about PHP, something about MySQL and even about the SQL language.

There are some references to articles and external links.

PhpMyAdmin on your hosting

It is also very common for your own hosting service to offer you PhpMyAdmin already correctly installed, so it is common for this tool to be installed locally but not so much on a remote server. Even locally, there are times when your development environment already comes with PhpMyAdmin. This you should verify.

In any case, when PhpMyAdmin is available on your hosting, you will generally have access to it visibly within your client area. If you have any questions, we suggest you ask the support team of your contracted accommodation.