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 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 or choose another name.  See [[http://wiki.amahi.org/index.php/Storage_and_file_sharing#Step_2:_Create_Shares Storage and File Sharing]] for guidance.
 
* Open a terminal window.  Become '''root''' and do the following:
 
* 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}}
 
* 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/sharename';
+
{{Text|Text=$cfg['UploadDir'] = '/var/hda/files/phpmyadmin';
$cfg['SaveDir'] = '/var/hda/files/sharename';}}
+
$cfg['SaveDir'] = '/var/hda/files/phpmyadmin';}}
 
* Save the file.
 
* Save the file.
  
 
[[Category:Apps]]
 
[[Category:Apps]]

Revision as of 00:19, 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 or choose another name. See [Storage and File Sharing] for guidance.
  • 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.