Appion

h1. Setup MySQL database

Refer to [[Start_with_existing_ANY_Linux_flavor_OS#2-Setup-MySQL-databases|Setup MySQL databases]]

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>