<div>
Pls check this once... <a href="http://www.mail-archive.com/mysql@lists.mysql.com/msg16280.html" rel="ugc">http://www.mail-archive.com/mysql@lists.mysql.com/msg16280.html</a> 
 
Your rename command should be (INSTEAD OF ALTER) 
 
RENAME TABLE old_table_name TO new_table_name; 

</div>

<div>
Hello 
 
Try to set 
lower_case_table_names = 2 

</div>

<div>
Ok i think i have everything now, 
MYSQL config changed lower case table names = 1 
PLESK &amp;&nbsp;phpmyadmin changed all tables in the db lower case 
Seem to have all controls working now 
 
Thanks for answering all my questions, here and before. 
I feel along the way i got some good information about linux,mysql,plesk 
 
<a href="https://www.experts-exchange.com/questions/24194271/Change-Mysql-Config-Linux-shell-access.html" rel="ugc">https://www.experts-exchange.com/questions/24194271/Change-Mysql-Config-Linux-shell-access.html</a> 
<a href="https://www.experts-exchange.com/questions/24192997/How-to-change-lower-case-table-names-to-1.html" rel="ugc">https://www.experts-exchange.com/questions/24192997/How-to-change-lower-case-table-names-to-1.html</a> 

</div>

<div>
and i almost did set lower_case_table_names = 2 but read somewhere that this is not advised for relation dbs
</div>

<div>
Sorry I did not really catch the question, that he has made changes to 0 instead of 1, then why not turn it back to 1. So it must be 1.
</div>

<div>
My initial problem was i need to change the value 0 to 1 but once i did that my plesk control panel &amp;&nbsp;MyPHPAdmin panel didnt work as they where installed when lower_case_table_names was set to 0. 
It's all working now.
</div>

<div>
Hello, 
 
had same problem. This solved it: on the database 'psa' run the following SQL commands: 
 
 

<pre><code class="code-10 nolinks" id="code-306978">RENAME TABLE APSApplicationItems to apsapplicationitems ;
RENAME TABLE APSCatalogUpdates to apscatalogupdates ;
RENAME TABLE APSClientApplicationItems to apsclientapplicationitems ;
RENAME TABLE APSLicenses to apslicenses ;
RENAME TABLE APSLicenseTypes to apslicensetypes ;
RENAME TABLE BackendCache to backendcache ;
RENAME TABLE BackupsRunning to backupsrunning ;
RENAME TABLE BackupsScheduled to backupsscheduled ;
RENAME TABLE BackupsSettings to backupssettings ;
RENAME TABLE BillingCache to billingcache ;
RENAME TABLE Cards to cards ;
RENAME TABLE ClientsTraffic to clientstraffic ;
RENAME TABLE Components to components ;
RENAME TABLE DashboardPreset to dashboardpreset ;
RENAME TABLE DashboardPresetConfig to dashboardpresetconfig ;
RENAME TABLE DatabaseServers to databaseservers ;
RENAME TABLE DomainServices to domainservices ;
RENAME TABLE DomainsTraffic to domainstraffic ;
RENAME TABLE IP_Addresses to ip_addresses ;
RENAME TABLE Limits to limits ;
RENAME TABLE ListsParams to listsparams ;
RENAME TABLE Logos to logos ;
RENAME TABLE MailLists to maillists ;
RENAME TABLE Modules to modules ;
RENAME TABLE NewsArticles to newsarticles ;
RENAME TABLE Notes to notes ;
RENAME TABLE Notifications to notifications ;
RENAME TABLE Parameters to parameters ;
RENAME TABLE Permissions to permissions ;
RENAME TABLE PersistentCache to persistentcache ;
RENAME TABLE PMM to pmm ;
RENAME TABLE PMMDefault to pmmdefault ;
RENAME TABLE Repository to repository ;
RENAME TABLE SBConfig to sbconfig ;
RENAME TABLE SBResellers to sbresellers ;
RENAME TABLE SBSites to sbsites ;
RENAME TABLE SiteAppFiles to siteappfiles ;
RENAME TABLE SiteAppPackages to siteapppackages ;
RENAME TABLE SiteAppResources to siteappresources ;
RENAME TABLE SiteApps to siteapps ;
RENAME TABLE SiteAppsHitsStat to siteappshitsstat ;
RENAME TABLE Skins to skins ;
RENAME TABLE SSOBranding to ssobranding ;
RENAME TABLE Templates to templates ;
RENAME TABLE TmplData to tmpldata ;
RENAME TABLE WebApps to webapps ;
RENAME TABLE Webmails to webmails;
</code></pre>
</div>

<div>
This is usefull :), cas i had to do all the tables by hand
</div>

<div>
<div class="content wysiwyg-content">
I managed to change MYSQL lower_case_table_names=1 instead of 0 
Running Linux Redhat with PLESK 9.01 
 
Unless i change value back to 0 i get an error on plesk login screen 
ERROR: PleskMainDBException 
MySQL query failed: Table 'psa.skins' doesn't exist 
 
0: /usr/local/psa/admin/plib/common_func.php3:168 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;db_query(string 'select `id`,`name`,`place` from Skins where `id`=18') 
1: /usr/local/psa/admin/plib/class.Table.php:183 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table-&gt;select() 
2: /usr/local/psa/admin/plib/skin/Skin.php:52 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Skin-&gt;Skin(integer '18') 
3: /usr/local/psa/admin/plib/common_func.php3:3115 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objectMaker(string 'Skin', integer '18') 
4: /usr/local/psa/admin/auto_prepend/auth.php3:485 

</div>
</div>

I managed to change MYSQL lower_case_table_names=1 instead of 0
Running Linux Redhat with PLESK 9.01

Unless i change value back to 0 i get an error on plesk login screen
ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:168
	db_query(string 'select `id`,`name`,`place` from Skins where `id`=18')
1: /usr/local/psa/admin/plib/class.Table.php:183
	Table->select()
2: /usr/local/psa/admin/plib/skin/Skin.php:52
	Skin->Skin(integer '18')
3: /usr/local/psa/admin/plib/common_func.php3:3115
	objectMaker(string 'Skin', integer '18')
4: /usr/local/psa/admin/auto_prepend/auth.php3:485


PLESK with Mysql varialbel lower_case_table_names = 1

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

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.

MySQL Server

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.