Installing phpMyAdmin on Mac

phpMyAdmin on Mac

1. Download the latest phpMyAdmin distribution

phpMyAdmin-x.x.x-english.tar.gz

2. Create folder ~/Sites/database/ and move distribution into the folder

mv ~/Downloads/phpMyAdmin-x.x.x-english.tar.gz ~/Sites/database/

2. Untar and make files executable

tar -xzvf phpMyAdmin-4.4.4-english.tar.gz

3. Most likely all files in the phpMyAdmin-... folder will have extra quarantine attributes

// check this by running
xattr -l <filename>

4. Recursively remove quarantine permissions

xattr -r -d com.apple.quarantine phpMyAdmin-x.x.x-english

5. Make sure you have correct permissions for Apache

sudo chown -R <you>:_www ~/Sites/database

6. Secure config file

sudo chmod 660 config.inc.php

7. Create Apache virtual host

<VirtualHost *:80>
    ServerAdmin admin@website.com
    DocumentRoot "/Users/<you>/Sites/database/phpmyadmin"
    ServerName local.mysql.com
    ErrorLog "/private/var/log/apache2/mysql.com-error_log"
    CustomLog "/private/var/log/apache2/mysql.com-access_log" common

    <Directory "/Users/<you>/Sites/database/phpmyadmin">
          Options Indexes FollowSymLinks
          AllowOverride All
          Require all granted
    </Directory>
</VirtualHost>

8. Add local.mysql.com to /etc/hosts