|
| PMA Database ... not OK General relation features Disabled |
 |
Thu, 09 Mar 2006 12:38:58 GMT |
Hi!
Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver.
4.0.15a, PHP 4.2.3, all of them on same machine.
Using the phpMyAdmin to build a new DB, I observed the "PMA Database ...
not OK General relation features Disabled " message.
In the above message is a link to a page with the following explanation that I
don't know how to use:
-----
$cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with
master / foreign - tables. To use those as well as the bookmark feature you need
special tables with a predefined structure, which we explain below.
If you are the only user of this phpMyAdmin installation, you can use your
current database to store those special tables; in this case, just put your
current database name in $cfg['Servers'][$i]['pmadb'].
If you are setting up a multi-user phpMyAdmin installation, you will need to
create a new db and setup special privileges, so, as superuser:
create a new database for phpmyadmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE
privileges on this database. Here is a query to set up those privileges (using
"phpmyadmin" as the database name, and "pma" as the
controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';
do not give any other user rights on this database.
enter the databasename in $cfg['Servers'][$i]['pmadb']
Please help
TIA
Nanu
|
| Post Reply
|
|
|
|
|
|
|
|
|
|