Install phpMyAdmin » History » Version 12
Anchi Cheng, 02/06/2014 02:03 PM
| 1 | 1 | Amber Herold | h1. Install phpMyAdmin |
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | 3 | Amber Herold | You are not required to install phpMyAdmin for Appion or Leginon, however, it is a useful tool for interfacing with the mysql databases. |
| 5 | |||
| 6 | 6 | Amber Herold | h2. Install supporting packages |
| 7 | 3 | Amber Herold | |
| 8 | 1 | Amber Herold | |_.Name:|_.Download site:|_.yum package name|_.SuSE rpm name| |
| 9 | 3 | Amber Herold | |PHP|http://php.net/downloads.php |php|| |
| 10 | |php-mysql| |php-mysql|| |
||
| 11 | |||
| 12 | 6 | Amber Herold | h2. Install phpMyAdmin |
| 13 | 3 | Amber Herold | |
| 14 | 1 | Amber Herold | If you have not already installed phpMyAdmin, do so. The yum installation is: |
| 15 | 3 | Amber Herold | <pre> |
| 16 | sudo yum -y install phpMyAdmin |
||
| 17 | </pre> |
||
| 18 | |||
| 19 | 6 | Amber Herold | h2. Configure phpMyAdmin |
| 20 | 3 | Amber Herold | |
| 21 | Edit the phpMyAdmin config file @/etc/phpMyAdmin/config.inc.php@ and change the following lines: |
||
| 22 | |||
| 23 | <pre> |
||
| 24 | 8 | Neil Voss | sudo nano /etc/phpMyAdmin/config.inc.php |
| 25 | </pre> |
||
| 26 | |||
| 27 | <pre> |
||
| 28 | 3 | Amber Herold | $cfg['Servers'][$i]['AllowRoot'] = FALSE; |
| 29 | 7 | Neil Voss | $cfg['Servers'][$i]['host'] = 'mysqlserver.INSTITUTE.EDU'; |
| 30 | 3 | Amber Herold | </pre> |
| 31 | |||
| 32 | Edit the phpMyAdmin apache config file @/etc/httpd/conf.d/phpMyAdmin.conf@ and change the following lines: |
||
| 33 | |||
| 34 | 8 | Neil Voss | <pre> |
| 35 | sudo nano /etc/httpd/conf.d/phpMyAdmin.conf |
||
| 36 | </pre> |
||
| 37 | 3 | Amber Herold | |
| 38 | 9 | Neil Voss | <pre> |
| 39 | 3 | Amber Herold | <Directory /usr/share/phpMyAdmin/> |
| 40 | order deny,allow |
||
| 41 | deny from all |
||
| 42 | 1 | Amber Herold | allow from 127.0.0.1 |
| 43 | 3 | Amber Herold | allow from YOUR_IP_ADDRESS |
| 44 | </Directory> |
||
| 45 | 10 | Neil Voss | </pre> |
| 46 | 3 | Amber Herold | |
| 47 | *Note:* If you want to access phpMyAdmin from another computer, you can also add it to this config file with an @allow from@ tag |
||
| 48 | |||
| 49 | 6 | Amber Herold | h2. Restart Web Server |
| 50 | 3 | Amber Herold | |
| 51 | Next restart the web server to take on the new setting |
||
| 52 | <pre> |
||
| 53 | sudo /sbin/service httpd restart |
||
| 54 | </pre> |
||
| 55 | |||
| 56 | 6 | Amber Herold | h2. Test the configuration |
| 57 | 3 | Amber Herold | |
| 58 | To test the phpMyAdmin configuration, point your browser to http://YOUR_IP_ADDRESS/phpMyAdmin or http://localhost/phpMyAdmin and login with the usr_object user. |
||
| 59 | |||
| 60 | 5 | Amber Herold | !http://emg.nysbc.org/attachments/177/phpMyAdmin.png! |
| 61 | 4 | Amber Herold | |
| 62 | 3 | Amber Herold | A common problem is that the firewall may be blocking access to the web server and mysql server. On CentOS/Fedora you can configure this with the system config: |
| 63 | |||
| 64 | <pre> |
||
| 65 | system-config-securitylevel |
||
| 66 | </pre> |
||
| 67 | |||
| 68 | Firewall configuration is specific to different Unix distributions, so consult a guide on how to do this on non-RedHat machines. |
||
| 69 | |||
| 70 | |||
| 71 | 1 | Amber Herold | |
| 72 | 12 | Anchi Cheng | [[Install phpMyAdmin shared]] |
| 73 | 1 | Amber Herold | |
| 74 | ______ |
||
| 75 | |||
| 76 | 11 | Amber Herold | [[Install Redux image server|< Install myamiweb and Redux]] | [[Potential Problems|Potential Problems >]] |
| 77 | 1 | Amber Herold | |
| 78 | ______ |