Difference between revisions of "PhpMyAdmin"

From Amahi Wiki
Jump to: navigation, search
Line 17: Line 17:
 
===Upload/Download Directory===
 
===Upload/Download Directory===
 
You can configure phpMyAdmin to use an Amahi Share for a SQL upload/download location.   
 
You can configure phpMyAdmin to use an Amahi Share for a SQL upload/download location.   
* Create a share called phpmyadmin.  See [[http://wiki.amahi.org/index.php/Storage_and_file_sharing#Step_2:_Create_Shares Storage and File Sharing]] for guidance.
+
* Create a share called 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.
* Open a terminal window.  Become '''root''' and do the following:
+
* If you want to use a different share, open a terminal window.  Become '''root''' and do the following:
 
{{Code|cd /var/hda/web-apps/phpmyadmin/html
 
{{Code|cd /var/hda/web-apps/phpmyadmin/html
 
vi config.inc.php}}
 
vi config.inc.php}}

Revision as of 21:48, 10 February 2011

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:
bash code
​cd /var/hda/web-apps/phpmyadmin/html vi config.inc.php​
  • Add this line to the end and change the name to the theme of your choice (i.e. paradice, Artic Ocean, Darkblue/orange)
Text
​$cfg['ThemeDefault'] = 'paradice';​
  • 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: Additional themes can be downloaded 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.
  • If you want to use a different share, open a terminal window. Become root and do the following:
bash 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
​$cfg['UploadDir'] = '/var/hda/files/phpmyadmin'; $cfg['SaveDir'] = '/var/hda/files/phpmyadmin';​
  • Save the file.