Difference between revisions of "PhpMyAdmin"

From Amahi Wiki
Jump to: navigation, search
 
(28 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Category:Apps]]
+
== TIPS ==
 +
The following items can be customized by modifying phpMyAdmin configuration file.
  
== TIPS ==
+
===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.
 +
* Open a terminal window.  Become '''root''' and do the following:
 
  cd /var/hda/web-apps/phpmyadmin/html
 
  cd /var/hda/web-apps/phpmyadmin/html
 
  vi config.inc.php
 
  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)
+
* 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'] = 'paradice';
+
$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.
+
* 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 [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 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 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.
 +
<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.