Difference between revisions of "PhpMyAdmin"

From Amahi Wiki
Jump to: navigation, search
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Category:Apps]]
 
 
 
== TIPS ==
 
== TIPS ==
 +
The following items can be customized by modifying phpMyAdmin configuration file.
  
 
===Themes===
 
===Themes===
* To set the default theme to something other than original, open a terminal window.  Become '''root''' and do the following:
+
The default theme can be changed permanently.
{{Code|cd /var/hda/web-apps/phpmyadmin/html
+
* Open a terminal window.  Become '''root''' and do the following:
vi config.inc.php}}
+
cd /var/hda/web-apps/phpmyadmin/html
* Add this line to the end and change the name to the theme of your choice (i.e. paradice, Artic Ocean, Darkblue/orange)
+
vi config.inc.php
{{Text|Text=$cfg['ThemeDefault'] = 'paradice';}}
+
* 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.
 
* 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.
 
* Access phpMyAdmin and you will see the new theme applied as default to the login screen.
  
  
'''NOTE:'''  Additional themes can be downloaded [http://www.phpmyadmin.net/home_page/themes.php here].
+
'''NOTE:''' For Amahi 7 or greater, ''blueorange'', ''Metro'', and ''Cleanstrap'' themes are installed by default. Additional themes can be found [http://www.phpmyadmin.net/home_page/themes.php here].
  
 
===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 the share.  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 [[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 share, open a terminal window.  Become '''root''' and do the following:
+
* To use a different share, open a terminal window.  Become '''root''' and do the following:
{{Code|cd /var/hda/web-apps/phpmyadmin/html
+
cd /var/hda/web-apps/phpmyadmin/html
vi config.inc.php}}
+
vi config.inc.php
* Change these 2 lines to reflect the path of the share you created:"
+
* Change these 2 lines to reflect the path of the share you created (near end of file):
{{Text|Text=$cfg['UploadDir'] = '/var/hda/files/sharename';
+
$cfg['UploadDir'] = '/var/hda/files/phpmyadmin';
$cfg['SaveDir'] = '/var/hda/files/sharename';}}
+
$cfg['SaveDir'] = '/var/hda/files/phpmyadmin';
 
* Save the file.
 
* Save the file.
 +
<br />
 +
 +
[[Category:Apps]]

Latest revision as of 01:06, 25 March 2016

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.