| phpmyadmin config problems [message #176680] |
Tue, 17 January 2012 03:59  |
cerr
Messages: 33
Registered: September 2010
Karma: 0
|
Member |
|
|
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
|
|
|
|
| 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: 0
|
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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]