phpBB.de

Code: Alles auswählen

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 database 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 database name in $cfg['Servers'][$i]['pmadb'] 



$cfg['Servers'][$i]['bookmarktable'] string 
Since release 2.2.0 phpMyAdmin allows to bookmark queries. This can be useful for queries you often run.

To allow the usage of this functionality you have to: 
set up "pmadb" as described above 
within this database create a table following this scheme: 
     CREATE TABLE `pma_bookmark` (
       id int(11) DEFAULT '0' NOT NULL auto_increment,
       dbase varchar(255) NOT NULL,
       user varchar(255) NOT NULL,
       label varchar(255) NOT NULL,
       query text NOT NULL,
       PRIMARY KEY (id)
     ) TYPE=MyISAM COMMENT='Bookmarks';

enter the table name in $cfg['Servers'][$i]['bookmarktable']