How To Change The Default MySQL Collation ?

[Alec:D]

If you want change the mysql collation setting permanently then you need to type the below entry in mysql configuration file.

e.g : if I want to set "utf8_general_ci" it as default

Resolution :

You need to access the server by SSH with root user :

Then edit the my.cnf file

[root@server~]# vi /etc/my.cnf
~~~~~~~~~~~~~~~
[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'

[client]
default-character-set=utf8
~~~~~~~~~~~~~~~

type the above entry and save the file

and simply restart the mysql service.

If you have Cpanel shared hosting package then you need to manually change the collation setting for your database as per your requirement from :

PHPMyadmin >> Operations >> Here you will see the "Collation" option

Done..