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!
Mysql Installation nightmare
Moderator: General Moderators
-
invisibled
- Forum Contributor
- Posts: 112
- Joined: Sun Apr 29, 2007 3:35 pm
- Location: New Westminster
-
invisibled
- Forum Contributor
- Posts: 112
- Joined: Sun Apr 29, 2007 3:35 pm
- Location: New Westminster
Re: Mysql Installation nightmare
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.
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.