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无法启动

#ExampleMySQLconfigfileformediumsystems.
#
#Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays
#animportantpart,orsystemsupto128MwhereMySQLisusedtogetherwith
#otherprograms(suchasawebserver)
#
#MySQLprogramslookforoptionfilesinasetof
#locationswhichdependonthedeploymentplatform.
#Youcancopythisoptionfiletooneofthose
#locations.Forinformationabouttheselocations,see:
#http://dev.mysql.com/doc/mysql/en/option-files.html
#
#Inthisfile,youcanusealllongoptionsthataprogramsupports.
#Ifyouwanttoknowwhichoptionsaprogramsupports,runtheprogram
#withthe"--help"option.

#ThefollowingoptionswillbepassedtoallMySQLclients
[client]
#password=your_password
port=3306
socket=/tmp/mysql.sock

#Herefollowsentriesforsomespecificprograms

#TheMySQLserver
[mysqld]
port=3306
socket=/tmp/mysql.sock
skip-external-locking
key_buffer_size=16M
max_allowed_packet=1M
table_open_cache=64
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
character-set-server=utf8
init_connect='SETNAMESutf8'

#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement,
#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.
#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.
#NotethatusingthisoptionwithoutenablingnamedpipesonWindows
#(viathe"enable-named-pipe"option)willrendermysqlduseless!
#
#skip-networking

#ReplicationMasterServer(default)
#binaryloggingisrequiredforreplication
log-bin=mysql-bin

#binaryloggingformat-mixedrecommended
binlog_format=mixed

#requireduniqueidbetween1and2^32-1
#defaultsto1ifmaster-hostisnotset
#butwillnotfunctionasamasterifomitted
server-id=1

#ReplicationSlave(commentoutmastersectiontousethis)
#
#Toconfigurethishostasareplicationslave,youcanchoosebetween
#twomethods:
#
#1)UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-
#thesyntaxis:
#
#CHANGEMASTERTOMASTER_HOST=<host>,MASTER_PORT=<port>,
#MASTER_USER=<user>,MASTER_PASSWORD=<password>;
#
#whereyoureplace<host>,<user>,<password>byquotedstringsand
#<port>bythemaster'sportnumber(3306bydefault).
#
#Example:
#
#CHANGEMASTERTOMASTER_HOST='125.564.12.1',MASTER_PORT=3306,
#MASTER_USER='joe',MASTER_PASSWORD='secret';
#
#OR
#
#2)Setthevariablesbelow.However,incaseyouchoosethismethod,then
#startreplicationforthefirsttime(evenunsuccessfully,forexample
#ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto
#connect),theslavewillcreateamaster.infofile,andanylater
#changeinthisfiletothevariables'valuesbelowwillbeignoredand
#overriddenbythecontentofthemaster.infofile,unlessyoushutdown
#theslaveserver,deletemaster.infoandrestarttheslaverserver.
#Forthatreason,youmaywanttoleavethelinesbelowuntouched
#(commented)andinsteaduseCHANGEMASTERTO(seeabove)
#
#requireduniqueidbetween2and2^32-1
#(anddifferentfromthemaster)
#defaultsto2ifmaster-hostisset
#butwillnotfunctionasaslaveifomitted
#server-id=2
#
#Thereplicationmasterforthisslave-required
#master-host=<hostname>
#
#Theusernametheslavewilluseforauthenticationwhenconnecting
#tothemaster-required
#master-user=<username>
#
#Thepasswordtheslavewillauthenticatewithwhenconnectingto
#themaster-required
#master-password=<password>
#
#Theportthemasterislisteningon.
#optional-defaultsto3306
#master-port=<port>
#
#binarylogging-notrequiredforslaves,butrecommended
#log-bin=mysql-bin

#UncommentthefollowingifyouareusingInnoDBtables
#innodb_data_home_dir=/usr/local/mysql/data
#innodb_data_file_path=ibdata1:10M:autoextend
#innodb_log_group_home_dir=/usr/local/mysql/data
#Youcanset.._buffer_pool_sizeupto50-80%
#ofRAMbutbewareofsettingmemoryusagetoohigh
#innodb_buffer_pool_size=16M
#innodb_additional_mem_pool_size=2M
#Set.._log_file_sizeto25%ofbufferpoolsize
#innodb_log_file_size=5M
#innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_lock_wait_timeout=50

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL
#safe-updates
default-character-set=utf8

[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout