[PHP-DB] PMA Database ... not OK General relation features Disabled
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PMA Database ... not OK General relation features Disabled
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PMA Database ... not OK General relation features Disabled
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
