phpmyadmin server error #2002

dfw123 · 04-23-2007, 07:20 PM

Hello!

I setup phpmyadmin on fedora6 and mysql 5.0 and use either ip or localhost, after I put username and password it had error:

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

I change the port to 3306 in config.inc.php, still not work. How do I fix it? Thanks.

bathory · 04-24-2007, 02:15 AM

Make sure that the mysqld daemon is running:

Code:

ps -ef|grep mysqld

dfw123 · 04-24-2007, 02:39 AM

yes, it is running and port 3306 is listening.

any suggestion?

bathory · 04-24-2007, 03:21 AM

If you use port 3306 to connect to mysql server then you must put

Code:

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

in your config.inc.php

dfw123 · 04-24-2007, 01:00 PM

yes, it is tcp.

bathory · 04-25-2007, 01:59 AM

Replace localhost with 127.0.0.1 to see if it fixes the problem.

dfw123 · 04-26-2007, 01:07 AM

tried it even can not find server. I found mysql can be started by "#mysqld_safe --user=mysql" but can not started by "service mysqld start". error : timeout occured when trying mysqld

It can be stopped by "service mysqld stop"
In the error log :
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
mysqld ended

any suggestion?

bathory · 04-26-2007, 01:51 AM

Make sure that the databases directory is owned by user/group mysql. Also since you use Fedora you should check SELinux settings as it often causes various problems regarding permissions.

dfw123 · 04-26-2007, 02:51 PM

I checked /var/lib/mysql and /var/lib/mysql/ibdata1 both are mysql user and group.

any suggestion?

bathory · 04-27-2007, 02:31 AM

Another suggestion is to take a look at mysql error logfile (located in the databases directory with a .err suffix). Also make sure that it's not a SELinux issue.

Regards