[[Category:Apps]]
== TIPS ==
The following items can be customized by modifying phpMyAdmin configuration file.
===Themes===
* To set the The default theme to something other than original, open can be changed permanently.* Open a terminal window. Become '''root''' and do the following:{{Code| cd /var/hda/web-apps/phpmyadmin/html vi config.inc.php}}* Add this text before the last line to of the end file and change the name to the theme of your choice (i.e. paradice''Cleanstrap'', Artic Ocean''blueorange'', Darkblue/orange''Original''){{Text|Text= $cfg['ThemeDefault'] = 'paradicemetro';}}
* Save the file and clear the web browser cache.
* Access phpMyAdmin and you will see the new theme applied as default to the login screen.
'''NOTE:''' For Amahi 7 or greater, ''blueorange'', ''Metro'', and ''Cleanstrap'' themes are installed by default. Additional themes can be downloaded found [http://www.phpmyadmin.net/home_page/themes.php here].
===Upload/Download Directory===
You can configure phpMyAdmin to use an Amahi Share for a SQL upload/download location.
* Create the a sharecalled phpmyadmin. See [[http://wiki.amahi.org/index.php/Storage_and_file_sharing#Step_2:_Create_Shares |Storage and File Sharing]] for guidance. No further action is required unless you want to use a different share name.* To set the use a different share, open a terminal window. Become '''root''' and do the following:{{Code| cd /var/hda/web-apps/phpmyadmin/html vi config.inc.php}}* Change these 2 lines to reflect the path of the share you created(near end of file):"{{Text|Text= $cfg['UploadDir'] = '/var/hda/files/sharenamephpmyadmin'; $cfg['SaveDir'] = '/var/hda/files/sharenamephpmyadmin';}}
* Save the file.
<br />
[[Category:Apps]]