Databases Reference
In-Depth Information
As this storage does not exist by default and because the phpMyAdmin team wants
to promote it, the interface displays the following notice message on the home page:
This message can be disabled with the following parameter (which, by default, is set
to
FALSE
):
$cfg['PmaNoRelation_DisableWarning'] = TRUE;
Performing the installation
The previous error message is displayed even if only a part of the configuration
storage is lacking. Of course, on a fresh installation, all parts are lacking—our
database has not yet heard of phpMyAdmin and needs to be outfitted with this
configuration storage. Following the
here
link in the previous screenshot brings up
a panel explaining that the
pmadb
, and the tables that are supposed to be a part of it,
are either missing or undefined.
It's important to realize that the configuration storage will be functional only if the
following two conditions are met:
• Proper deinitions are present in
config.inc.php
• The corresponding tables (and maybe the database) are created
To create the necessary structure that matches our current version of phpMyAdmin,
a command file called
create_tables.sql
is available in the
scripts
sub-directory
of the phpMyAdmin installation directory. However, we should not blindly
execute it before understanding the possible choices—single-user installation or
multi-user installation.
In subsequent chapters, we will assume that the multi-user
installation has been chosen.
Installing for a single user
Even if we are entitled to only one database by the system administrator, we can still
use all the advanced features of phpMyAdmin. In this setup, we will use our existing
database to store the metadata tables.
Search WWH ::
Custom Search