mysql mac下解决MySQL中文乱码的问题

mac osx 10.9

mysql 5.5

安装mysql的dmg文件后，将/usr/local/mysql/support-files中的任意一个.cnf文件copy到/etc/目录并重命名为my.cnf

修改my.cnf

找到[mysqld] 添加

character-set-server=utf8chatracter-set-server=utf8

init_connect='SET NAMES utf8'

找到[mysql]

default-character-set=utf8

然后重启mysql服务。

注：如果在mysqld中添加的是default-character-set=utf8，则会导致mysql无法启动

[html] view plain copy

1. #ExampleMySQLconfigfileformediumsystems.
2. #
3. #Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays
4. #animportantpart,orsystemsupto128MwhereMySQLisusedtogetherwith
5. #otherprograms(suchasawebserver)
6. #
7. #MySQLprogramslookforoptionfilesinasetof
8. #locationswhichdependonthedeploymentplatform.
9. #Youcancopythisoptionfiletooneofthose
10. #locations.Forinformationabouttheselocations,see:
11. #http://dev.mysql.com/doc/mysql/en/option-files.html
12. #
13. #Inthisfile,youcanusealllongoptionsthataprogramsupports.
14. #Ifyouwanttoknowwhichoptionsaprogramsupports,runtheprogram
15. #withthe"--help"option.
17. #ThefollowingoptionswillbepassedtoallMySQLclients
18. [client]
19. #password=your_password
20. port=3306
21. socket=/tmp/mysql.sock
23. #Herefollowsentriesforsomespecificprograms
25. #TheMySQLserver
26. [mysqld]
27. port=3306
28. socket=/tmp/mysql.sock
29. skip-external-locking
30. key_buffer_size=16M
31. max_allowed_packet=1M
32. table_open_cache=64
33. sort_buffer_size=512K
34. net_buffer_length=8K
35. read_buffer_size=256K
36. read_rnd_buffer_size=512K
37. myisam_sort_buffer_size=8M
38. character-set-server=utf8
39. init_connect='SETNAMESutf8'
41. #Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement,
42. #ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.
43. #AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.
44. #NotethatusingthisoptionwithoutenablingnamedpipesonWindows
45. #(viathe"enable-named-pipe"option)willrendermysqlduseless!
46. #
47. #skip-networking
49. #ReplicationMasterServer(default)
50. #binaryloggingisrequiredforreplication
51. log-bin=mysql-bin
53. #binaryloggingformat-mixedrecommended
54. binlog_format=mixed
56. #requireduniqueidbetween1and2^32-1
57. #defaultsto1ifmaster-hostisnotset
58. #butwillnotfunctionasamasterifomitted
59. server-id=1
61. #ReplicationSlave(commentoutmastersectiontousethis)
62. #
63. #Toconfigurethishostasareplicationslave,youcanchoosebetween
64. #twomethods:
65. #
66. #1)UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-
67. #thesyntaxis:
68. #
69. #CHANGEMASTERTOMASTER_HOST=<host>,MASTER_PORT=<port>,
70. #MASTER_USER=<user>,MASTER_PASSWORD=<password>;
71. #
72. #whereyoureplace<host>,<user>,<password>byquotedstringsand
73. #<port>bythemaster'sportnumber(3306bydefault).
74. #
75. #Example:
76. #
77. #CHANGEMASTERTOMASTER_HOST='125.564.12.1',MASTER_PORT=3306,
78. #MASTER_USER='joe',MASTER_PASSWORD='secret';
79. #
80. #OR
81. #
82. #2)Setthevariablesbelow.However,incaseyouchoosethismethod,then
83. #startreplicationforthefirsttime(evenunsuccessfully,forexample
84. #ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto
85. #connect),theslavewillcreateamaster.infofile,andanylater
86. #changeinthisfiletothevariables'valuesbelowwillbeignoredand
87. #overriddenbythecontentofthemaster.infofile,unlessyoushutdown
88. #theslaveserver,deletemaster.infoandrestarttheslaverserver.
89. #Forthatreason,youmaywanttoleavethelinesbelowuntouched
90. #(commented)andinsteaduseCHANGEMASTERTO(seeabove)
91. #
92. #requireduniqueidbetween2and2^32-1
93. #(anddifferentfromthemaster)
94. #defaultsto2ifmaster-hostisset
95. #butwillnotfunctionasaslaveifomitted
96. #server-id=2
97. #
98. #Thereplicationmasterforthisslave-required
99. #master-host=<hostname>
100. #
101. #Theusernametheslavewilluseforauthenticationwhenconnecting
102. #tothemaster-required
103. #master-user=<username>
104. #
105. #Thepasswordtheslavewillauthenticatewithwhenconnectingto
106. #themaster-required
107. #master-password=<password>
108. #
109. #Theportthemasterislisteningon.
110. #optional-defaultsto3306
111. #master-port=<port>
112. #
113. #binarylogging-notrequiredforslaves,butrecommended
114. #log-bin=mysql-bin
116. #UncommentthefollowingifyouareusingInnoDBtables
117. #innodb_data_home_dir=/usr/local/mysql/data
118. #innodb_data_file_path=ibdata1:10M:autoextend
119. #innodb_log_group_home_dir=/usr/local/mysql/data
120. #Youcanset.._buffer_pool_sizeupto50-80%
121. #ofRAMbutbewareofsettingmemoryusagetoohigh
122. #innodb_buffer_pool_size=16M
123. #innodb_additional_mem_pool_size=2M
124. #Set.._log_file_sizeto25%ofbufferpoolsize
125. #innodb_log_file_size=5M
126. #innodb_log_buffer_size=8M
127. #innodb_flush_log_at_trx_commit=1
128. #innodb_lock_wait_timeout=50
130. [mysqldump]
131. quick
132. max_allowed_packet=16M
134. [mysql]
135. no-auto-rehash
136. #RemovethenextcommentcharacterifyouarenotfamiliarwithSQL
137. #safe-updates
138. default-character-set=utf8
140. [myisamchk]
141. key_buffer_size=20M
142. sort_buffer_size=20M
143. read_buffer=2M
144. write_buffer=2M
146. [mysqlhotcopy]
147. interactive-timeout