This article covers how to install PhpMyAdmin on Mac OS X. PhpMyAdmin is a software tool written in PHP to manage and administer MySQL databases. It supports not only MySQL, but also MariaDB and Drizzle databases. PhpMyAdmin supports a variety of database operations such as managing databases, tables, columns, relations, indexes, users, and permissions.
This article is part of a series of articles on how to manually install Apache, PHP, MySQL on the Mac OS. Installing the popular MAMP application is as simple as installing any other application on the Mac, but it will not give you any valuable learning experience, nor will you have complete control of your development environment. I recommend manually installing the individual applications to maximize your learning experience.
How to Install PhpMyAdmin on Mac OS X
To install PhpMyAdmin, download the latest version.
Unzip the file and rename the folder to ‘phpmyadmin.’
Move the ‘phpmyadmin’ folder to ‘/usr/local/phpmyadmin.’
$ sudo mv phpmyadmin /usr/local/phpmyadmin |
Copy the config.sample.inc.php to config.inc.php.
$ cd /usr/local/phpmyadmin $ sudo cp config.sample.inc.php config.inc.php |
Create a config file in ‘/etc/apache2/other.’
$ sudo touch /etc/apache2/other/phpmyadmin.conf |
Edit the config file.
$ sudo nano /etc/apache2/other/phpmyadmin.conf |
Add the following:
Alias /phpmyadmin /usr/local/phpmyadmin
<Directory /usr/local/phpmyadmin>
Options Indexes
Order allow,deny
Allow from all
</Directory> |
Restart Apache
$ sudo apachectl restart |
Finally, access PhpMyAdmin from your browser. Example: http://localhost/phpmyadmin