Install phpMyAdmin » History » Revision 8
Revision 7 (Neil Voss, 07/15/2011 03:02 PM) → Revision 8/13 (Neil Voss, 01/06/2012 09:39 AM)
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> sudo nano /etc/phpMyAdmin/config.inc.php </pre> <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: <pre> sudo nano /etc/httpd/conf.d/phpMyAdmin.conf </pre> <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 >]] ______