Server Administration & Management

How to change MySQL database collation from PhpMyAdmin in cPanel

Sometimes its require to change MySQL collation in the web hosting account to use foreign character encoding. There are many ways to change MySQL collation. Here are the following steps to change MySQL collation from PhpMyAdmin in cPanel:

1. Login to your cPanel and click on “PhpMyAdmin” icon.
2. Click on your database name and the go to “Operations” tab.
3. At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.

Please note that the new collation will be set for new tables only. Old table will use the previous collation under which they were created. If we want to use new collation for already created tables, we will need to change collation for all tables.

January 16, 2011 Posted by | cPanel, MySQL | , , , | 6 Comments