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 >]]
______