If you’re not into using XAMPP/MAMP for your local development sandbox and you’d like to go with the stack that comes preinstalled on a Mac, you could have trouble configuring phpMyAdmin.

For a successful phpMyAdmin configuration the usual requirements are that you have a fast and easy way to access the databases meaning no login. Below is the configuration that delivers it:

<?php
/**
* phpMyAdmin configuration
*
* For local development sandbox on Mac OS X
* with Mac-bundled PHP and Apache instances
*
* phpMyAdmin 3.5.2
*/
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* End of servers configuration */
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
/* Remove login requirement */
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/* Turn on Database DROP */
$cfg['AllowUserDropDatabase'] = true;
/* Turn off PHP mcrypt complaints */
$cfg['McryptDisableWarning'] = true;
?>
view raw config.inc.php hosted with ❤ by GitHub