<div>
You can do this by setting in my.cnf.. add below line to mysql's config file under mysqld group.. unfortunately you cannot set this dynamically so you need to add it to the file and restart MySQL<br />
<br />
<br />
lower_case_table_names = 1<br />
<br />
<br />

</div>


<div>
would u by any chance know how can i accomplish this trough PLESK control Panel?<br />
<br />

</div>


<div>
I got to the Services management,<br />
I can stop and start Appache server there.<br />
<br />
But how in the world to to get to the config file
</div>


<div>
my.cnf should be in /etc ... open a terminal and search locate my.cnf<br />
<br />

</div>


<div>
To start and stop MySQL normally this is the process(on linux)<br />
<br />
/etc/init.d/mysql stop<br />
<br />
/etc/init.d/mysql start
</div>


<div>
Sorry I have no idea about PLESK...........
</div>


<div>
Thank's<br />
But im still stuck in plesk, cant find how to run a command to access the file system 
</div>


<div>
lower_case_table_names is not a dynamic variable, so you can't set it while the mysql server is running using 'SET variable=value' (<a href="http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html</a>). <br />
You need to specify this at startup using option --lower-case-table-names=1<wbr />. Alternatively you can define it in an option file: <a href="http://dev.mysql.com/doc/refman/5.1/en/option-files.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/option-files.html</a>
</div>


<div>
Thanks,<br />
Will post another question on Plesk
</div>


<div>
<div class="content wysiwyg-content">
I found solution for my case sensitivity problem:<br />
i need to set<br />
lower_case_table_names=1<br />
so MYSQL on my remote server(linux) is not case senisitive.<br />
<br />
But how to actually change this value? 
</div>
</div>


I found solution for my case sensitivity problem:
i need to set
lower_case_table_names=1
so MYSQL on my remote server(linux) is not case senisitive.

But how to actually change this value? 

How to change lower_case_table_names to 1

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.