Wednesday, March 21, 2012

phpmyadmin on MacOsX native


After enabling httpd (apache), php and installing mysql, the next step is to get a great tool like phpmyadmin working on apache.
Download phpmyadmin and extract it in the document root. I renamed the folder to phpmyadmin ofcourse.
cp config.sample.inc.php config.inc.php 
vi /Library/Webservers/Documents/phpmyadmin/config.inc.php

change 
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
to
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

chmod o+r config.inc.php
In my case, my server location and port number are the default localhost:3306 so I don't have much changes in the file. 

Now if you go to http://localhost/phpmyadmin/ you should see the login screen. Login with an existing user/passwd. If you don't have one, I would encourage you to create one via the GUI tool MySQL Administrator, which is natively delivered by MySQL.

Notes: The default connection type is set to Cookie and not Socket. So the browser's cookie settings need to be compliant. If socket is desirable then the path typically is /tmp/mysql.sock.

No comments :

Powered by Blogger.