Project

General

Profile

Actions

Database Server Installation » History » Revision 2

« Previous | Revision 2/32 (diff) | Next »
Amber Herold, 03/15/2010 04:11 PM


Setup MySQL database

Refer to Setup MySQL databases
Note: the above link includes unnessary steps....
Start Here: http://emg.nysbc.org/documentation/leginon/bk02ch04s07.php

Configure MySQL

Edit the configuration file:

$ sudo nano /etc/my.cnf

Add or edit the following lines:

query_cache_type = 1
query_cache_size = 100M
query_cache_limit= 100M

Restart MySQL

$ sudo /sbin/service mysqld restart

Configure phpMyAdmin

Edit the phpMyAdmin config file:

$ sudo nano /etc/phpMyAdmin/config.inc.php

and change the following lines:

$cfg['Servers'][$i]['AllowRoot']     = FALSE;

Edit the phpMyAdmin apache config file:

$ sudo nano /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>

Updated by Amber Herold almost 15 years ago · 2 revisions