Can't start phpmyadmin. Keep getting the #2002 socket error

Did you configure MySQL to use the same socket path that PHP is using?

https://discussions.apple.com/docs/DOC-3082

Sorry, but that is just a hack that will fail when you reboot.

I think you may be going too quickly. Get the web server setup and running. Install PHP. Install MySQL and verify that works. Make sure PHP and MySQL agree on the socket port. Only then install phpMyAdmin and make sure it is using the correct socket port too. I think that is where your problem lies.

Sets the type of connection to 'http' solved the problem for me, example of my config.inc.php:

$cfg['Servers'][$i]['verbose'] = '';

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['port'] = '3306';

$cfg['Servers'][$i]['socket'] = '/opt/local/var/run/mysql55/mysqld.sock';

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

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = '<your mysql username here>';

$cfg['Servers'][$i]['password'] = '<your password here>';

Because I was using MAMP and now trying to use OS X Server only and postgreSQL thought after having lost an hour on the matter to explain the configuration I have to cross link OS X Server PHP to MAMP's mySQL :

To avoid conflict you need to set MAMP's apache port to something else OS X Server websites.

Thus by doing so you must allow remote access to mySQL.

Default parameters would then be :

host : localhost

port : 3306 or other if specified

socket : /Applications/MAMP/tmp/mysql/mysql.sock

connection type : socket

Which worked absolutely fine using :

<?php

var_dump(new mysqli('localhost','user','password','database',3306,'/Applications/MAMP/tmp/mysql/mysql.sock'));

?>

With phpMyAdmin consider installing another instance else where and be aware of cookies issues test with a dummy.php file that it works thus if you get a #2002 error delete the cookie...

When I get rid of MAMP I'll go straight to the MySQL Community Server and fetch the latest DMG Archive.

ebaranov wrote:

$cfg['Servers'][$i]['socket'] = '/opt/local/var/run/mysql55/mysqld.sock';

If you are using some 3rd/4th party build, you have to configure everything according to how that software expects to find it. In this case, the UNIX sockets would be at different places and you would probably have to use TCP.

Same old story. You can get pretty much any configuration to run. You just have to figure out how OS X Server is configured, what settings MAMP is using, etc. and adjust them all so that they will talk to each other. There isn't a wrong answer per se, as long as you get it to work. The key part is to understand why so you don't have to reinvent the wheel each time you port to a different server.

Indeed, thought it can always be usefull to have some snippets available when ones is in need of some help...

The trick is the choose the right snippets. There is a hunge number of possible configurations that will work fine. The only thing bigger is the number of configurations that won't work 🙂