Databases Reference
In-Depth Information
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']
. For example, a server may have more than one
name, or we may be trying to use the IP address instead of the name.
Column Size Changed by phpMyAdmin
MySQL itself sometimes decides to change the column type and size, for a more
efficient column definition. This happens mostly with
CHAR
and
VARCHAR
.
Seeing many Databases that Are Not Ours
This problem occurs mostly after an upgrade to MySQL 4. The automatic server
upgrade procedure gives the global privileges
CREATE
TEMPORARY
TABLES
,
SHOW
DATABASES
, and
LOCK
TABLES
to all users. These privileges also enable
users to see the names of all the databases (but not their tables) until we upgrade
the grant tables as described in the MySQL manual. If the users do not need these
privileges, we can revoke them, and they will only see the databases to which they
are entitled.
Not Being Able to Store a Value Greater than 127
This is normal if we have defined a column of type
TINYINT
, since 127 is the
maximum value for this column type. Similar problems may arise with other numeric
column types. Changing the type to
INT
expands the available range of values.
Seeking Support
The starting point for support is the home page
http://www.phpmyadmin.net
,
which has sections about documentation and support (feedback). There you will find
links to the discussion forums and to various trackers such as:
•
•
Bugs tracker
Feature requests tracker
Search WWH ::
Custom Search