I’m setting up an Apache server (localhost only) on my Win7 laptop. I’ve got it all working, with PHP and mySQL, but I’m having a problem with the finer points of configuring phpMyAdmin. (Even so, phpMyAdmin is working OK).
I think it must be because I’ve not got ‘config.inc.php’ quite right. This is what I have:
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
/* Contrib / Swekey authentication */
//$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';
$cfg['LoginCookieValidity'] = 1800;
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
When I log in to phpMyAdmin I get the following notice at the bottom of the screen: “The additional features for working with linked tables have been deactivated. To find out why click here”. When I ‘click here’ I get a new page (within phpMyAdmin) saying:
" Server: localhost
$cfg[‘Servers’][$i][‘pmadb’] … OK
$cfg[‘Servers’][$i][‘relation’] … not OK [ Documentation ]
General relation features: Disabled
$cfg[‘Servers’][$i][‘table_info’] … not OK [ Documentation ]
Display Features: Disabled
$cfg[‘Servers’][$i][‘table_coords’] … not OK [ Documentation ]
$cfg[‘Servers’][$i][‘pdf_pages’] … not OK [ Documentation ]
Creation of PDFs: Disabled
$cfg[‘Servers’][$i][‘column_info’] … not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled
$cfg[‘Servers’][$i][‘bookmarktable’] … not OK [ Documentation ]
Bookmarked SQL query: Disabled
$cfg[‘Servers’][$i][‘history’] … not OK [ Documentation ]
SQL history: Disabled
$cfg[‘Servers’][$i][‘designer_coords’] … not OK [ Documentation ]
Designer: Disabled"
I have followed the documentation, and created a database called ‘phpmyadmin’, which contains all the tables which are meant to be configured, and I’ve checked that the table names are the same as those set in ‘config.inc.php’. But so far to no avail. I’m possibly missing out something rather simple, can anyone tell me what it is, please ?