Appion

Appion Home » Appion Manual » Complete Installation »

Database Server Installation » History » Revision 2

Revision 1 (Amber Herold, 03/15/2010 03:59 PM) → Revision 2/32 (Amber Herold, 03/15/2010 04:11 PM)

h1. Setup MySQL database 

 Refer to [[Start_with_existing_ANY_Linux_flavor_OS#2-Setup-MySQL-databases|Setup MySQL databases]] 
 Note: the above link includes unnessary steps.... 
 Start Here: http://emg.nysbc.org/documentation/leginon/bk02ch04s07.php 

 h2. Configure MySQL  

 Edit the configuration file: 

 <pre> 
 $ sudo nano /etc/my.cnf 
 </pre> 

 Add or edit the following lines: 

 <pre> 
 query_cache_type = 1 
 query_cache_size = 100M 
 query_cache_limit= 100M 
 </pre> 

 Restart MySQL 

 <pre> 
 $ sudo /sbin/service mysqld restart 
 </pre> 

 h2. Configure phpMyAdmin  

 Edit the phpMyAdmin config file: 

 <pre> 
 $ sudo nano /etc/phpMyAdmin/config.inc.php 
 </pre>  

 and change the following lines: 

 <pre> 
 $cfg['Servers'][$i]['AllowRoot']       = FALSE; 
 </pre> 

 Edit the phpMyAdmin apache config file: 

 <pre> 
 $ sudo nano /etc/httpd/conf.d/phpMyAdmin.conf 
 </pre> 

 and change the following lines: 

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