View Single Post
Old 9th March 2010, 20:15
jnsc jnsc is offline
Join Date: Mar 2006
Location: Lausanne, Switzerland
Posts: 531
Thanks: 11
Thanked 175 Times in 79 Posts
Default phpMyAdmin 3.3.0 default configuration


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, 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'] = ''; (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.

Last edited by jnsc; 10th March 2010 at 11:28.
Reply With Quote
Sponsored Links