In the phpMyAdmin package we had a huge configuration file with many options, but as it is quite difficult to maintain, I was trying to remove all the options that had the default value set. I checked every option, and now I want to discuss every option in this forum. There are not so much, so please give me your feedback, especially for the tricky ones. The default value and explanation can be found over here http://wiki.phpmyadmin.net/pma/Config
, So here we GO:
$cfg['PmaAbsoluteUri'] = $go_info["server"]["server_url"].'/phpmyadmin/'; (Default is empty, and should work. As it's a package we know where it's gone be installed, but does someone know why we use this value?)
$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|pmadb|test)'; (Quite obvious, does someone want to change anything?)
$cfg['ServerDefault'] = 1; (We should not touch this one)
$cfg['DisplayDatabasesList'] = FALSE; (default value in 2.10.0, Has been changed to 'auto' since 2.11.0, what should we use?)
$cfg['DefaultTabDatabase'] = 'db_structure.php'; (Default is 'tbl_structure.php')
$cfg['DefaultTabDatabase'] = 'db_structure.php'; (Default is 'db_details_structure.php')
$cfg['Export']['csv_enclosed'] = '"'; we will use the default value as this is an error.
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en'; (Maybe we should use the new URL?)
$cfg['MySQLManualType'] = 'searchable'; (Default is 'viewable', which one should we choose?)
$cfg['DefaultPropDisplay'] = 3; (Since 2.10.0 the default is 'horizontal')
$cfg['AttributeTypes'] = array(
); ('on update CURRENT_TIMESTAMP' has been added since 3.0.0)
In some other types we had 'HEX', 'UNHEX', they are not listed in the wiki should we keep them? why?
Now, the hard Part :
$cfg['DefaultLang'] = 'en-iso-8859-1'; (Since 3.0.0 'en-utf-8', which one, and why?)
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci'; (Since 3.0.0 'utf8_general_ci', which one, and why?)
$cfg['DefaultCharset'] = 'iso-8859-1'; (Since 3.0.0 'en-utf-8', which one, and why?)
So thanks in advance for your input.