If you use Apache web server, phpMyAdmin exports information about authentication to the Apache environment and it can be used in Apache logs. Currently there are two variables available:

userID
User name of currently active user (he does not have to be logged in).
userStatus
Status of currently active user, one of ok (user is logged in), mysql-denied (MySQL denied user login), allow-denied (user denied by allow/deny rules), root-denied (root is denied in configuration), empty-denied(empty password is denied).

LogFormat directive for Apache can look like following:

LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %{userID}n %{userStatus}n"   pma_combined

You can then use any log analyzing tools to detect possible break-in attempts.

For RedHat users, Harald Legner suggests this on the mailing list:

On my RedHat-Box the socket of MySQL is I get “Missing parameters” errors, what can I do? /var/lib/mysql/mysql.sock. In your I get “Missing parameters” errors, what can I do? php.ini you will find a line

I get “Missing parameters” errors, what can I do?  mysql.default_socket = I get “Missing parameters” errors, what can I do?  /tmp/mysql.sock

change it to

I get “Missing parameters” errors, what can I do?  mysql.default_socket = I get “Missing parameters” errors, what can I do?  /var/lib/mysql/mysql.sock

Then restart apache and it will work.

Here is a fix suggested by Brad Ummer:

  • First, you need to determine what socket is being used by MySQL. To do this, telnet to your server and go to the MySQL bin directory. In this directory there should be a file named mysqladmin. Type ./mysqladmin variables, and this should give you a bunch of info about your MySQL server, including the socket ( /tmp/mysql.sock, for example).
  • Then, you need to tell PHP to use this socket. To do this in phpMyAdmin, you need to complete the socket information in the I get “Missing parameters” errors, what can I do?config.inc.php. For example: I get “Missing parameters” errors, what can I do?$cfg['Servers'][$i]['socket'] Please also make sure that the permissions of this file allow to be readable by your webserver (i.e. ‘0755’).

Posted in: PhpMyAdmin

Related FAQ's

Marius Ion ANGEL HOT SOFT LLC (800) 316-7677