How to change Database Collation in MySQL Server from phpMyAdmin?

Collation is a configuration level setting in the MySQL. It directs how the character data will be handled by the MySQL Database with in the server, database, or column level.

You can change the Database Collation using the SQL Commands as well as from GUI. Following are the steps to change the Collation for a Database in MySQL from phpMyAdmin.

Note: Consult your Database/Web Developer before making these changes.

  1. Log in to the phpMyAdmin.

  2. Select your Database and click on the Operations Button.



  3. Select the required Collation from the Collation Drop-Down.



  4. Click on the Go Button.

You have changed the Database Collation successfully.

Related Articles

Where do I upload my files/folders in Shared Hosting plans?

All the files associated with your website must be placed inside the root folder of your domain....

Can I modify the php.ini file in shared hosting?

You can’t modify php.ini file if you have purchased shared hosting service.  If you are looking...

What Nameservers should I set to my website?

Nameservers information will be available in the login details email. You can also contact our...

How to Install WordPress Manually in Linux Shared Hosting?

We offer one click installer Softaculous to our Linux Shared Hosting customers to install popular...

How many IP addresses do you offer with Shared Hosting Account and a VPS Account?

We do not offer any dedicated IP address with shared hosting plans. If you purchase SSL...

  • 0 Users Found This Useful

Was this answer helpful?