We can do a quick check by going back to the Home page: the warning
message should be gone.
??? ??? ??? ??? ??? ??? ??? ???
The Relational System
[ 176 ]
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.)
Be warned that this script will erase the special tables, if they exist,
destroying all metadata about relations.
If we are using scripts/create_tables.sql, the modification we have to do is to
remove the following lines:
DROP DATABASE `phpmyadmin`;
CREATE DATABASE `phpmyadmin`;
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.
Pages:
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176