Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.



This step has to be performed before creating the database. Restart MySQL for any setting change in my.cnf.

Editing my.cnf file

If The 'my.cnf'file is usually present in the MySQL directory. , then add the following lines in the file.


The database server running on Linux has default character encoding is latin1. Change this property add the following line in /etc/my.cnf file under  

Add below line below [mysqld] section:


  character  character-set-server=utf8

  Add below lines above the [mysqld] session.