Installing phpMyAdmin

phpMyAdmin is used to administer a MySQL database over the Internet; it is a crucial tool that web hosting companies offer so their customers can administer their databases via the web interface. It is a FOSS tool written in PHP. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user-friendly interface. You can also execute any SQL statement directly via the query window.

1. Security

This setup is for a WAMP dev box. No considerations have been made regarding security.

2. My dev box setup

I am running a fairly typical Windows Apache MySQL PHP (“WAMP”) environment.

2.1 Apache

I have Apache HTTP Server 2.4 serving up index.php for directories:

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
    DirectoryIndex index.php
</IfModule>

2.2 PHP

PHP is installed in this location: C:\php

2.3 MySQL

I set up my MySQL database using MySQL Installer. I already have the server running with the demo databases and a test database or two that I created.

3. Download

Downloads are available on phpMyAdmin.net . At the time of writing this, phpMyAdmin 5.2.1 was the latest stable version. I grabbed the phpMyAdmin-5.2.1-english.zip  download.

4. Install

Unzip the contents of the downloaded file into C:\Apache24\htdocs\phpmyadmin

5. Setup

Go to http://localhost/phpmyadmin. Depending on your php.ini (the PHP configuration file) you may receive the following mysqli error:

This means that PHP needs MySQLi extensions (the “i” is for “improved”). The mysqli extension should be in the following location: C:\php\ext\php_mysqli.dll

Search for the following entry in your php.ini:

;extension=mysqli

Uncomment the above line (delete the semi-colon) and save the file.

Restart Apache

6. config

There is a sample phpMyAdmin config C:\Apache24\htdocs\phpmyadmin\config.sample.inc.php

There is also a setup wizard: http://localhost/phpmyadmin/setup

References:

1. contributors, phpMyAdmin (no date) phpMyAdmin. Available at: https://www.phpmyadmin.net/ (Accessed: 5 June 2024).
2. contributors, phpMyAdmin (no date) Downloads, phpMyAdmin. Available at: https://www.phpmyadmin.net/downloads/ (Accessed: 5 June 2024).
3. phpMyAdmin 5.1.4 documentation. (no date) Installation¶ . Available at: https://docs.phpmyadmin.net/en/latest/setup.html#quick-install-1 (Accessed: 5 June 2024).