2 Common errors while setting up phpMyAdmin on Mac OSX

You might encounter the following two errors while installing phpMyAdmin on OSX

  • Login without password is forbidden by the configuration ( See AllowNoPassword )
  • #2002 can not login tot the MySQL server

Here are the fixes for the above two errors.

1. Open phpMyAdmin configuration located at (phpMyAdmin Folder)/config.inc.php and change

$cfg['Servers'][$i]['AllowNoPassword'] = False; to $cfg['Servers'][$i]['AllowNoPassword'] = true;

2. In the configuration file change  $cfg['Servers'][$i]['host'] = 'localhost'; to $cfg['Servers'][$i]['host'] = '';

Where is httpd.conf file in Mac OSX Lion

On mac httpd.conf file is located in the directory /etc/apache2/. You can access it through terminal if you want to navigate to it through finder, on finder toolbar goto go->go to folder and type in /etc/apache2

Open hidden folders in mac osx
Navigate to hidden folders in MAC

Navigating to system files on MAC OSX
Navigating to system files on MAC OSX

Make command not found in Mac OSX

If you get a -bash: make: command not found error while trying to compile from source, you have to install xcode and then in xcode goto preferences->downloads and install xcode developer tools

installing command line tools on MAC OSX
installing command line tools on MAC OSX

Download Xcode

I’m not sure if you can install command lines without xcode. I can not test as I already have Xcode on my system you can download command line tools here