Groups > Novell > MySQL with Novell > PMA Database ... not OK General relation features Disabled




PMA Database ... not OK General relation features Disabled

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
about | contact