The next
step is to change root's password. (See Chapter 17.) Then we can stop the MySQL
server and restart it using normal procedures. (Security will become active again.)
Duplicate Field Names when Creating a Table
Here is a curious symptom: when we try to create a table containing, for example,
one field named FIELD1 of type VARCHAR(15), it looks like phpMyAdmin has sent
a command to create two identical fields named FIELD1. The problem is not caused
by phpMyAdmin, but by the environment. In this case, the Apache web server seems
well configured to run PHP scripts, when in fact, it is not. However, this bug only
appears for some scripts.
Chapter 20
[ 303 ]
The problem occurs when two different (and conflicting) sets of directives are used
in the Apache configuration file:
SetOutputFilter PHP
SetInputFilter PHP
...and:
AddType application/x-httpd-php .php
These sets of directives may be in two different Apache configuration files, so they are
difficult to notice. The recommended way is to use AddType, so we just have to put
comments on the other lines, as shown in the following snippet, and restart Apache:
#SetOutputFilter PHP
#SetInputFilter PHP
Authentication Window Displayed More Than Once
This problem occurs when we try to start phpMyAdmin with a URL other than the
one set in $cfg['PmaAbsoluteUri'].
Pages:
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275