hi
i'm using phpmyadmin 2.3.0 to manage a mysql 3.23.53 server. an older version of phpmyadmin i've worked with had some nifty features for copying both the data and the structure of a table to a new table. when i try to use those features on this install of phpmyadmin, i find the message
error - The additional Features for working with linked Tables have been deactivated. To find out why click here
when i click the link, i'm taken to a blank page with no instructions for how to enable these features.
i've done some googling - the most information i could find about this issue states
<snip>
$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
will need to create a new db.
To use this functionality as superuser create a new database:
a.. 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.
b.. enter the databasename in $cfg['Servers'][$i]['pmadb']
</snip>
i've created the phpmyadmin database and granted user pma the appropriate privileges for it. however, there is no
$cfg['Servers'][$i]['pmadb']
line in my config.inc.php file where i can poing phpmyadmin to the phpmyadmin db. when i try to add this line, phpmyadmin no longer works - can't bring up the index page due to sql errors...
can anyone tell me how to get this working?
thanks