topic Re: Re : PHPMYADMIN in Operating System - Linux

Re : PHPMYADMIN

Narasimhan — Fri, 06 May 2005 01:31:40 GMT

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

Re: Re : PHPMYADMIN

Florian Heigl (new acc) — Fri, 06 May 2005 07:23:28 GMT

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

Re: Re : PHPMYADMIN

Laurent Laperrousaz — Sat, 07 May 2005 10:59:02 GMT

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

Re: Re : PHPMYADMIN

Alex Lavrov. — Sat, 07 May 2005 14:12:09 GMT

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.

Re: Re : PHPMYADMIN

Stuart Browne — Sat, 07 May 2005 20:01:18 GMT

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.