Setup utf-8 as standard character set for a mysql server

MySense

add this into my.cnf:

1. [mysqld]
   
2. character-set-server=utf8
   
3. character-sets-dir=/usr/share/mysql/charsets
   
4. default-character-set=utf8
   
5. 
   
6. [mysql]
   
7. character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
   
8. 
   
9. [mysqladmin]
   
10. character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
    
11. 
    
12. [mysqlcheck]
    
13. character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
    
14. 
    
15. [mysqldump]
    
16. character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
    
17. 
    
18. [mysqlimport]
    
19. character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
    
20. 
    
21. [mysqlshow]
    
22. character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
    
23. #end

复制代码

It looks like default-character-set is no longer allowed in the [mysqld] section