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

Between each phpMyAdmin version, the infrastructure may be enhanced. (The
changes are explained in Documentation.html .) This is why phpMyAdmin has
various checks to ascertain the structure of the tables. If we know we are using the
latest structure, $cfg['Servers'][$i]['verbose_check'] can be set to FALSE to
avoid checks, thereby slightly increasing phpMyAdmin's speed.

The installation is now complete. We will test the features in the coming sections
and chapters. We can do a quick check by going back to the homepage; the warning
message should be gone.

Single-user installation
Even if we are entitled to only one database by the system administrator, we can still
use all the relational features of phpMyAdmin.

In this setup, we will use our normal database (let's assume its name is marc_book )
to store the metadata tables, and will define our own login name ( marc ) as the
control user in config.inc.php .

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

The next step is to modify a local copy of the scripts/create_tables.sql
file to populate our database with all the needed tables. They will have the
prefix pma_ to make them easily recognizable. (See also the remark in the
Multi-user installation section about other scripts that may be available in the
scripts directory.)

If we are using scripts/create_tables.sql , the modification we need is to
remove the following lines:

CREATE DATABASE IF NOT EXISTS `phpmyadmin`
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;

This is done because we won't be using a phpmyadmin database. Next, we should
open our marc_book database in phpMyAdmin. We are now ready to execute the
script. There are two ways of doing this:

• As we already have the script in our editor, we can just copy the lines and

paste them in the query box of the SQL subpage.
Another way is to use the import technique shown in Chapter 8. We select •

the c reate_tables.sql script that we just modified.