phpmyadmin #2002 error

curos · 07-18-2005, 12:03 AM

I am attempting to install phpmyadmin, but when I try to open it up, I receive the error

Quote:

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

I'm not sure how to proceed.

Here are some stats if it helps.
Slackware 10.1
Apache 2.054
php 4.40
mysql 4.1.11

Some key lines from the phpMyAdmin config.inc.php file

Code:

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'socket';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')

I checked to see if mysql was running with

Code:

ps xa | grep mysqld

And it was according to this ouput:

Code:

  822 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid
  851 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  852 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  853 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  854 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  855 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  856 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  858 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  859 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  860 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock
  861 ?        S      0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking --port=3306 --socket=/var/run/mysql/mysql.sock

Background: I installed AMP from the instructions provided by xushi with the exception that I installed php4 instead of php5. When it came to the instructions to edit php.ini:

Quote:

uncomment the line ;extension=mysql.so by removing the ';'
============

code:

Code:

extension=mysql.so

I just added the line 'extension=mysql.so' since there was no line to comment out.

gbonvehi · 07-18-2005, 12:09 AM

Try setting: $cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.sock';

or $cfg['Servers'][$i]['connect_type'] = 'tcp';
(try this if the socket doesn't work).

curos · 07-18-2005, 01:11 AM

it works! but now I've hit another snag.

The page now pops up with

Quote:

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.

and the error

Quote:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

And after googling a bit on the error, it seems that this shouldn't be happening since I have a current mysql version: 4.1.11

But maybe, I'm wrong, the instructions over at the mysql website http://dev.mysql.com/doc/mysql/en/old-client.html say that I can run the command

Code:

mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

and my question is, where and how do i run those commands if I need to at all?

davidsrsb · 07-18-2005, 01:55 AM

The old_password conversion is needed for some mysql based applications that use php 4 to access a mysql 4.1 database as the php4 mysql connector uses the mysql 4.0 api. PHP 5 works ok, but is not backwards compatible

gbonvehi · 07-18-2005, 02:23 AM

Quote:

Originally posted by curos
But maybe, I'm wrong, the instructions over at the mysql website http://dev.mysql.com/doc/mysql/en/old-client.html say that I can run the command

Code:

mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

and my question is, where and how do i run those commands if I need to at all?

You've to run that using the mysql client. Connect your your server using: mysql
and run the command on it.

Edit: By the way, here's a step by step how to get it working: http://forums.mysql.com/read.php?11,...0611#msg-10611

curos · 07-18-2005, 02:33 AM

Oh, so it's php4 that needs the old_password conversion. gbonvehi, I've run the command and everythings working.

Thank you everyone!!!