With over twelve years experience writing software, the Aboutbox can make your project a reality. We have the real-world business experience to understand your needs and the imagination and technical skills to deliver it to you on time.

PHPMyAdmin on Mac OS X

Posted November 19th, 2008 by admin

Most Web hosts have PHPMyAdmin installed as the interface to manage a MySQL Database. It’s full-featured and easy to use. It runs well in Mac OS X Leopard, but there are a few tweaks that are necessary to make.

To Install:

 

  • Download the latest stable version from phpmyadmin.net
  • Decompress the tarball in your Sites directory
  • Rename the folder to something shorter, like ‘phpmyadmin’
  • Go to ~/Sites/phpmyadmin and copy config.sample.inc.php to config.inc.php
  • Edit config.inc.php
  • Change line 31 to
$cfg['Servers'][$i]['host'] = '127.0.0.1';
  • Optionally change line 35 to
$cfg['Servers'][$i]['extension'] = 'mysqli';
The reason to change the host to 127.0.0.1 is because phpMyAdmin will try to connect through the socket if the host is localhost regardless of the ‘connect-type’ setting. The default mysql installation puts mysql.sock in /private/var/tmp, but the mysql and mysqli extensions look for it in /var/tmp/mysql.
Changing the extension to mysqli is mainly a performance improvement.
At this point, you can tweak the auth_type and DB credentials to your heart’s content.
Filed under:Uncategorized

Leave a Reply