Mar 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.
vi /Library/Webservers/Documents/phpmyadmin/

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

chmod o+r
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.

Whatsapp Button works on Mobile Device only

Start typing and press Enter to search