I have followed all the instructions on all tutorials I have found on properly setting up phpmyadmin via http auth. However, I keep getting Access Denied after entering a valid username and password. Here is an excerpt from my config.inc.php file, and my users table in mysql:
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = '3306'; // 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'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = 'louapol'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = 'w5t99rxgbllv'; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = '';
Host User password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections
localhost root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0 Bytes] [BLOB - 0 Bytes] [BLOB - 0 Bytes] 0 0 0
% root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0 Bytes] [BLOB - 0 Bytes] [BLOB - 0 Bytes] 0 0 0
localhost Y Y Y Y Y Y Y Y Y Y Y Y Y Y N N N N N N N [BLOB - 0 Bytes] [BLOB - 0 Bytes] [BLOB - 0 Bytes] 0 0 0
% Y Y Y Y Y Y N N N Y Y N Y Y N N Y N N N N [BLOB - 0 Bytes] [BLOB - 0 Bytes] [BLOB - 0 Bytes] 0 0 0
localhost louapol 1025582504ba1488 N N N N N N N N N N N N N N N N N N N N N [BLOB - 0 Bytes] [BLOB - 0 Bytes] [BLOB - 0 Bytes] 0 0 0
% lapolonia 29ecbc244be554c8 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0 Bytes] [BLOB - 0 Bytes] [BLOB - 0 Bytes] 0 0 0
Can anyone help? Should I provide more information? Any comments/help are greatly appreciated.
Thanks in advance,
Lou
