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.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to install Invoice Ninja using Softaculous?

Softaculous is an application installer of cPanel. We can install Invoice Ninja through...

What Nameservers should I set to my website?

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

What is the URL to access my webmail?

For our Linux users, the webmail URL is https: //www.<yourdomainname.com>:2096. For our...

How to Install Sample Data in Magento?

This tutorial will teach you how to install Magento E-Commerce website with sample data (demo...

Parse HTML As PHP Using HTACCESS File

There are times wherein you are required to parse HTML web pages as PHP. Suppose, you have older...