The Relational System - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 170

It's important to realize that the relational system will work only if two conditions
are met:

• Proper definitions 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 subdirectory
of the phpMyAdmin installation directory. However, we should not blindly
execute it before understanding the possible choices—multi-user installation or
single-user installation.

Multi-user installation
In this setup, we will have a distinct database— pmadb — to store the metadata tables.
Our control user will have specific rights to this database. Each user will work with
his/her login name and password, which will be used to access his/her databases.
However, whenever phpMyAdmin itself accesses pmadb to obtain some metadata, it
will use the control user's privileges.

Setting a multi-user installation is possible only for a MySQL system
administrator who has the privileges of assigning rights to another user
(here, the pma user). If you are not in this situation, please refer to the
Single-user installation section .

We first ensure that the control user pma has been created, as explained in Chapter 2,
and that its definition in config.inc.php is appropriate.

$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'bingo';

We then look in the scripts directory for create_tables.sql . There might be
the other scripts available for different MySQL versions, so we should pick the one
which looks the most appropriate. Next, we copy this script to our local workstation
and edit it. We replace the following lines:

-- GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
-- 'pma'@localhost;

with these:

GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
'pma'@localhost;