Databases Reference
In-Depth Information
We first ensure that the control user
pma
has been created and that its definition in
config.inc.php
is appropriate. We then copy
scripts/create_tables.sql
to our
local workstation and edit it. We replace the following lines:
-- GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
-- 'pma'@localhost;
with these, removing the comment characters (double-dash):
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
'pma'@localhost;
We then execute this script by importing it (refer to
Chapter
7
). The net effect is to
create the
phpmyadmin
database, assign proper rights to user
pma
, and populate the
database with all the necessary tables.
The last step is to adjust all the parameters in
config.inc.php
that relate to
relational features. Please refer to the
Installing
for
a
single
user
section, except for
the database name in the
pmadb
parameter, which will be as shown in the following
code snippet:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
The installation is now complete. We will test the features in the coming sections and
chapters. We can do a quick check by logging out of phpMyAdmin, then logging in
and displaying the home page; the warning message should be gone.
Upgrading phpMyAdmin
Normally, upgrading is just a matter of installing the newer version into a separate
directory and copying the previous version's
config.inc.php
to the new directory.
An upgrade path or the first-installation path, which should
not
be taken,
is to copy
libraries/config.default.php
to
config.inc.php
.
This is because the default configuration file is version-specific, and is not
guaranteed to work for the future versions.
New parameters appear from version to version. They are documented in
Documentation.html
and defined in
libraries/config.default.php
. If
a configuration parameter is not present in
config.inc.php
, its value from
libraries/config.default.php
will be used. Therefore, we do not have to
include it in
config.inc.php
if the default value suits us.
Search WWH ::
Custom Search