phpMyAdmin configuration for macOS-bundled PHP and Apache
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:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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; | |
?> |