PhpMyAdmin

TIPS

The following items can be customized by modifying phpMyAdmin configuration file.

Themes

The default theme can be changed permanently.

• Open a terminal window. Become root and do the following:

cd /var/hda/web-apps/phpmyadmin/html
vi config.inc.php

• Add this text before the last line of the file and change the name to the theme of your choice (i.e. Cleanstrap, blueorange, Original)

$cfg['ThemeDefault'] = 'metro';

• 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 found here.

Upload/Download Directory

You can configure phpMyAdmin to use an Amahi Share for a SQL upload/download location.

• Create a share called phpmyadmin. See Storage and File Sharing for guidance. No further action is required unless you want to use a different share name.
• To use a different share, open a terminal window. Become root and do the following:

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):

$cfg['UploadDir'] = '/var/hda/files/phpmyadmin';
$cfg['SaveDir'] = '/var/hda/files/phpmyadmin';

• Save the file.