Solved

Getting phpMyAdmin to work on Mac OS X

Posted on 2007-03-17
3
3,161 Views
Last Modified: 2008-01-09
Does anyone here know how to configure phpMyAdmin to work on a Mac OS X?  I have tried so many times with different versions and I keep getting the same error message:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Which I don't understand why I would be getting this message since I am using:

$cfg['Servers'][$i]['connect_type'] = 'tcp';

Can anyone help me out here?  The code to my config.inc.php file is below.

<?php

/* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use scripts/setup.php
 *
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki <http://wiki.cihar.com>.
 */

/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'anything'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>
0
Comment
Question by:pingeyeg
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
gamebits earned 500 total points
ID: 18740242
I dont have a Mac so I cannot try any of that but there is a link that might help you

http://www.servercodex.com/archives/2003/07/02/phpmyadmin-on-mac-os-x/
0
 
LVL 1

Author Comment

by:pingeyeg
ID: 18740249
Yea, I've already tried that numerous times.  I just don't understand what I am missing since i am running this on my test server here on my own computer.  This is not going onto the Internet.  I tried the demo on phpMyAdmin.net and it worked great, but on my mine it won't.  Arg!
0
 
LVL 1

Author Comment

by:pingeyeg
ID: 18740413
YYYYYYYYYEEEEEEEEEEEEESSSSSSSSSSSSSSSSS!!!!!!!!!!!!!!!!!!  I finally got it to work.  I had to change the connect-type to socket and specify the socket to /tmp/mysql.sock.  Now it WORKS!!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question