Project

General

Profile

Install phpMyAdmin » History » Version 7

Neil Voss, 07/15/2011 03:02 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
$cfg['Servers'][$i]['AllowRoot']     = FALSE;
25 7 Neil Voss
$cfg['Servers'][$i]['host']          = 'mysqlserver.INSTITUTE.EDU';
26 3 Amber Herold
</pre>
27
28
Edit the phpMyAdmin apache config file @/etc/httpd/conf.d/phpMyAdmin.conf@ and change the following lines:
29
30
31
<Directory /usr/share/phpMyAdmin/>
32
   order deny,allow
33
   deny from all
34 1 Amber Herold
   allow from 127.0.0.1
35 3 Amber Herold
   allow from YOUR_IP_ADDRESS
36
</Directory>
37
38
*Note:* If you want to access phpMyAdmin from another computer, you can also add it to this config file with an @allow from@ tag
39
40 6 Amber Herold
h2. Restart Web Server
41 3 Amber Herold
42
Next restart the web server to take on the new setting
43
<pre>
44
sudo /sbin/service httpd restart
45
</pre>
46
47 6 Amber Herold
h2. Test the configuration
48 3 Amber Herold
49
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.
50
51 5 Amber Herold
!http://emg.nysbc.org/attachments/177/phpMyAdmin.png!
52 4 Amber Herold
53 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:
54
55
<pre>
56
system-config-securitylevel
57
</pre>
58
59
Firewall configuration is specific to different Unix distributions, so consult a guide on how to do this on non-RedHat machines.
60
61
62 1 Amber Herold
63
64
65
______
66
67 2 Amber Herold
[[Install the Web Interface|< Install the Web Interface]] | [[Potential Problems|Potential Problems >]]
68 1 Amber Herold
69
______