Troubleshooting and Support - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 302

When using http, cookie, or config authentication
The host parameter in config.inc.php must match the host defined in the user
access privileges. Sometimes, a system administrator may create an account
authorizing user bill and host localhost . If we try to use 127.0.0.1 host in
config.inc.php , it will be rejected by MySQL even though it points to the same
machine. The same problem can occur if we try the real name of the machine
( mysql.domain.com ) and the definition has been made for localhost .
Access denied ... "using password: NO"
If the message ends with using password: NO , it means that we are not transmitting
a password, and MySQL is rejecting this login attempt. The password value may not
have been set in config.inc.php .
Access denied ... "using password: YES"
A password is transmitted, but the host/username/password combination has been
rejected by MySQL.
Warning: cannot add header information
This problem is caused by some characters (such as blank lines or spaces) being
present in config.inc.php —either before the <?php tag at the beginning, or after
the ?> tag at the end. We should remove these with an editor that supports .php iles
(as discussed in Chapter 1).
MySQL said: Error 127, Table Must Be Repaired
In the left panel, we click on the database name. In the right panel, we select the name
of the table for which there is an error (using the relevant checkbox). We then choose
Repair from the lower drop-down list. More details are available in Chapter 10.
BLOB column used in key specification without a
key length
MySQL requires that an index set on a BLOB column be limited in size. The simple
index creation technique available when creating a column, does not permit the size
to be specified. Therefore, we need to create the column without an index. We then
come back to the Structure page, and use the Create an index dialog to choose the
BLOB column and set a size for the index.