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