Setup MySQL database¶

Refer to Setup MySQL databases

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>