mamp-upgrading-phpmyadmin.md

mamp-upgrading-phpmyadmin.md

Updating phpMyAdmin in MAMP

When using MAMP, you may want to upgrade the version of phpMyAdmin. Or for example, after upgrading my MAMP version of PHP, phpMyAdmin started display a lot of PHP warnings.

These are the steps to upgrade phpMyAdmin:

1. Download the dsired version of phpMyAdmin.

2. Extract the files and give the folder a nice clean name. I renamed my folder from phpMyAdmin-5.2.0-all-languages to phpmMyAdmin5.

3. Move your phpMyAdmin5 folder to /Applications/MAMP/bin/phpMyAdmin5/.

4. Inside the phpMyAdmin5 folder, create a copy of the config.sample.inc.php and name it config.inc.php. Update the database connection information. I updated mine to:

$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = '8889';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

5. Open the Apache httpd.conf. On my system is was located in /Applications/MAMP/conf/apache/httpd.conf.

6. Find the existing alias for /phpmyadmin and add a new Alias for /phpMyAdmin5:

Alias /phpMyAdmin5 "/Applications/MAMP/bin/phpMyAdmin5"
Alias /phpmyadmin5 "/Applications/MAMP/bin/phpMyAdmin5"

<Directory "/Applications/MAMP/bin/phpMyAdmin5">
  Options Indexes MultiViews
  AllowOverride None
  Require all granted
</Directory>

7. Restart Apache and the open the new phpMyAdmin tool in your browser using the new alias: http://localhost:8888/phpMyAdmin5.