Databases Reference
In-Depth Information
USE phpmyadmin;
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
'pma'@localhost;
This is done because we won't be using the
phpmyadmin
database or the
pma
control user.
We are now ready to execute the script. There are two ways of doing this:
•
Since we already have the script in our editor, we can just copy the lines and
paste them in the query box of the
SQL
sub-page.
Another way is to use the technique shown in Chapter 8 (
Importing Structure
and Data
), with the
SQL
sub-page and the file selector. We select the
create_
tables.sql
script that we just modified.
•
After the creation, the left panel shows us the special
pma_
tables along with our
normal tables:
The last step is to adjust all the parameters in
config.inc.php
that relate to
relational features. Except for the database name in the
pmadb
parameter, we use the
default values mentioned in the comments inside the file:
$cfg['Servers'][$i]['pmadb'] = 'dbbook';
The Relation View
After the installation of the linked-tables infrastructure, there are now more options
available in the Database view and the Table view. We will now examine a new link
in the Table view:
Relation view
. This view is used to:
Search WWH ::
Custom Search