Re: phpmyadmin config problems [message #176697 is a reply to message #176680] |
Wed, 18 January 2012 14:33 |
Erwin Moller
Messages: 228 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 1/17/2012 4:59 AM, cerr wrote:
> Hi There,
>
> Hi There,
>
> I'm getting
> #2002 - The server is not responding (or the local MySQL server's
> socket is not correctly configured)
> even tho I have this in my config.inc.php:
>
> $cfg['Servers'][$i]['auth_type'] = 'cookie';
> /* Server parameters */
> $cfg['Servers'][$i]['host'] = 'localhost';
> $cfg['Servers'][$i]['user'] = 'root';
> $cfg['Servers'][$i]['password'] = 'PASS';
> $cfg['Servers'][$i]['connect_type'] = 'tcp';
> $cfg['Servers'][$i]['compress'] = false;
> /* Select mysqli if your server has it */
> $cfg['Servers'][$i]['extension'] = 'mysql';
> $cfg['Servers'][$i]['AllowNoPassword'] = false;
>
> and
> mysql -u root -p
>
> on the shell lets me login just fine. Why would phpmyadmin not be
> able to connect? I also got troubles connecting to my db with
> Joomla... :(
>
> Any help is appreciated!
> Thank you!
> Ron
Hi Ron,
This is no PHPmyadmin group. :-)
You might get luckier in their forum.
This thread explains a few common mistakes:
http://forums.mysql.com/read.php?35,64808,64808
Read it. :-)
A wild suggestions: use
$cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';
instead of tcp.
Regards,
Erwin Moller
--
"That which can be asserted without evidence, can be dismissed without
evidence."
-- Christopher Hitchens
|
|
|