How to change mysql collation using cpanel

If your are experiencing problems with some characters save ate your database after you have restored a database from your notebook or your old host, its always a good practice to check for the collation of your old database.
MySQL used to use Latin1 as the default, but most web hosts use MySQL’s default collation as utf8.

If you wanna change, just follow this 4 steps:


1. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.

2. Select the database you wish to manage from the drop-down menu on the left

3. Click on the Operations tab in the top menu of your phpMyAdmin

4. 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 after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.
In this case, if you were restoring a database from your home or from your old server, delete all tables, follow the steps above and restore the database again.

Was this answer helpful?

 Print this Article

Also Read

How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....

Accessing mysql remotely

1) Access your cPanel(http://your_domain/cpanel). 2) Click in icon of Remote MySQL. 3) Inside,...

How to delete a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....

How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....

How to create a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....