Databases Reference
In-Depth Information
When Using http Authentication
We cannot use the web server security mechanism based on a
.htaccess
file and the
http
authentication in
config.inc.php
together. A workaround is to use
cookie
as
the authentication type instead of
http
.
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 2).
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
Search WWH ::
Custom Search