Project

General

Profile

Install phpMyAdmin » History » Revision 7

Revision 6 (Amber Herold, 05/24/2010 04:45 PM) → Revision 7/13 (Neil Voss, 07/15/2011 03:02 PM)

h1. Install phpMyAdmin 


 You are not required to install phpMyAdmin for Appion or Leginon, however, it is a useful tool for interfacing with the mysql databases.  

 h2. Install supporting packages 

 |_.Name:|_.Download site:|_.yum package name|_.SuSE rpm name| 
 |PHP|http://php.net/downloads.php |php|| 
 |php-mysql| |php-mysql|| 

 h2. Install phpMyAdmin 

 If you have not already installed phpMyAdmin, do so. The yum installation is: 
 <pre> 
 sudo yum -y install phpMyAdmin 
 </pre> 

 h2. Configure phpMyAdmin 

 Edit the phpMyAdmin config file @/etc/phpMyAdmin/config.inc.php@ and change the following lines: 

 <pre> 
 $cfg['Servers'][$i]['AllowRoot']       = FALSE; 
 $cfg['Servers'][$i]['host']            = 'mysqlserver.INSTITUTE.EDU'; 
 </pre> 

 Edit the phpMyAdmin apache config file @/etc/httpd/conf.d/phpMyAdmin.conf@ and change the following lines: 


 <Directory /usr/share/phpMyAdmin/> 
    order deny,allow 
    deny from all 
    allow from 127.0.0.1 
    allow from YOUR_IP_ADDRESS 
 </Directory> 

 *Note:* If you want to access phpMyAdmin from another computer, you can also add it to this config file with an @allow from@ tag 

 h2. Restart Web Server 

 Next restart the web server to take on the new setting 
 <pre> 
 sudo /sbin/service httpd restart 
 </pre> 

 h2. Test the configuration 

 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. 

 !http://emg.nysbc.org/attachments/177/phpMyAdmin.png! 

 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: 

 <pre> 
 system-config-securitylevel 
 </pre> 

 Firewall configuration is specific to different Unix distributions, so consult a guide on how to do this on non-RedHat machines. 





 ______ 

 [[Install the Web Interface|< Install the Web Interface]] | [[Potential Problems|Potential Problems >]] 

 ______