Difference between revisions of "PhpMyAdmin"

From Amahi Wiki
Jump to: navigation, search
Line 19: Line 19:
 
* 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.
 
* 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.
 
* To use a different 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 (near end of file):
 
* Change these 2 lines to reflect the path of the share you created (near end of file):
{{Text|Text=$cfg['UploadDir'] = '/var/hda/files/phpmyadmin';
+
$cfg['UploadDir'] = '/var/hda/files/phpmyadmin';
$cfg['SaveDir'] = '/var/hda/files/phpmyadmin';}}
+
$cfg['SaveDir'] = '/var/hda/files/phpmyadmin';
 
* Save the file.
 
* Save the file.
  
 
[[Category:Apps]]
 
[[Category:Apps]]

Revision as of 20:30, 27 March 2015

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 line to the end and change the name to the theme of your choice (i.e. paradice, Artic Ocean, Darkblue/orange)
$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: 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.
  • 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.