Page 1 of 1

Mysql Installation nightmare

Posted: Wed Jun 04, 2008 2:40 am
by invisibled
Ok so i just got a new 24" iMac (woooooo), with leopard,

I've been trying to install mysql and phpmyadmin for like 5 hours now and i can access mysql fine from terminal, everything appears to be working jsut fine. however, I always get this error when i try to run my phpmyadmin. It says there is an error trying to connect to the socket or its not properly configured.

I have read that this is a problem with leopard and have tryed to apply the fix's but still no luck. I might just be setting up the config.inc.php for phpmyadmin wrong, so maybe could anybody post there configs that i can copy and try out on mine?

If anybody knows a good tutorial or method for installing mysql and/or phpmyadmin that would be great too!

Re: Mysql Installation nightmare

Posted: Wed Jun 04, 2008 3:40 pm
by invisibled
ahh i figured it out, for anybody who see's this here is a little guide to follow.

1. Follow this guide EXACTLY: http://hivelogic.com/articles/2007/11/i ... n-mac-os-x

2. then run the following commands:
sudo mkdir /var/mysql/

sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

3. use the following code in your config.inc.php file for phpmyadmin

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.11.6 setup script by Michal Čihař <michal@cihar.com>
* Version: $Id: setup.php 10748 2007-10-10 07:30:59Z cybot_tm $
* Date: Wed, 04 Jun 2008 12:50:52 GMT
*/

$cfg['blowfish_secret'] = ''; //set this to whatever

/* Servers configuration */
$i = 0;

/* Server localhost (config:) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

/* End of servers configuration */
?>

i made a note of this myself to save me from screwing this up again.