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 the ?> tag at the end. We should remove these with an editor that supports .php files
(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.
Chapter 20
[ 301 ]
BLOB Column Used in Key Specification without a
Key Length
MySQL requires that an index set on a BLOB column be limited in size.
Pages:
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272