Re : PHPMYADMIN

[Narasimhan]

Hello
I am running MySQL-3.23 and php-4.3 on FC3. I have installed
phpMyAdmin but when I type http://localhost/phpMyAdmin, I get an
error message like this :

" phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) " .

I restarted httpd, mysql and tried, but it fails.Could anyone please reply ?
Thanks
Narasimhan

[Florian Heigl (new acc)]

Somewhere the credentials for phpmyadmin's access to Your database must be set, obviously they aren't or contain a default user.

[Laurent Laperrousaz]

the credentials for MySQL users must be set :
1) in MySQL you check that a user can log in from localhost. If so:

2) set this user (and password) in the config.inc.php file for the host "localhost"

Be careful to set the host correctly because the host name is important for MySQL

[Alex Lavrov.]

check my.conf file. It's usually can be located in /etc/my.conf and be sre that both srever and client a trying to connect on the same socket.

[Stuart Browne]

Nah, this is as simple as not following all the instructions.

In the default 'config.inc.php', there is a whole section on what database servers it can access, with default user-names and passwords entered in there.

They haven't been altered.

Also, there is a special user that usually needs to be added to MySQL to enable the PHPMyAdmin to read some details.

The README file gives the instructions on what SQL commands need to be executed in MySQL before it will all work cleanly.

It's a special user, with specific grants.