设置Mysql数据库的默认编码为utf8
首页 | 注册 | 登录 | 用户群体 | 关于我们 Rss Feed
Guides.rubyonrails.org
Skip navigation .
敏捷开发最佳实践 GemDigger 问题交流 书籍资料 职位招聘 线下活动Ruby on Rails 敏捷开发最佳实践分享
分享你的敏捷开发最佳实践，为rails社区的枝繁叶茂做出自己的贡献.
Agile Web Development With Rails Fourth Edition
设置Mysql数据库的默认编码为utf8
1 次投票
sunny 分享于 26 天 前, 2 条回复 , 104 次浏览
Share |
mysql的默认编码为latin1，存储中文时总会出现乱码，每次改过了，下次又忘了该怎么配，把它记录下来，也分享给各位。
进入mysql，查看默认编码：
$ mysql -uroot -proot $ show variables like character%'
显示字符编码：
+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+
现暂停mysql服务：
$sudo /etc/init.d/mysql stop
修改 /etc/mysql/my.cnf
$ sudo chmod 777 /etc/mysql/my.cnf $ vim /etc/mysql/my.cnf
在 client 下面加上：
default-character-set=utf8
在 mysqld 下面加上：
default-character-set=utf8 init_connect='SET NAMES utf8'
保存，退出wq
重启mysql服务：
$sudo /etc/init.d/mysql start
发现出错：
Warning: World-writable config file '/etc/mysql/my.cnf' is ignored /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'luoping'@'localhost' (using password: NO)'
原因为：/etc/mysql/my.cnf 权限太高，搜索了一番，有人说许改为600，但是我发觉不行，查看了/etc/mysql/文件夹里的其他文件，权限是755，所以修改权限
$sudo chmod 755 /etc/mysql/my.cnf
重启mysql服务，OK
再次查看数据库编码
$ mysql -uroot -proot $ show variables like character%'
显示字符编码：
+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+database
相关最佳实践 解决Mysql::Error: query: not connected by hywhy
回复 (2 条)
0 支持
# 1 楼
貌似用windows的同学容易有这个数据库默认的编码问题。
0 支持
# 2 楼
windows上更容易点吧，安装的时候有提示，可以自己选择编码，不用像linux安装完了在改配置文件
添加回复
你的大名 *
如果你还未注册， 请填写你的名字。
你可以实用以下html标签:
<a href="" title=""> <b> <blockquote> <pre> <code> <em> <i> <strong>
代码块请使用 <pre><code>...</code></pre>.
关于我们 线下活动 用户群体 Rss Feed
All rights resolved by Thoughtrails.com 2010
Bookmark & Share X
AOL
Bloglines
Google Reader
My MSN
Netvibes
Newsisfree
Pageflakes
Yahoo
.netShoutout
100zakladok
2 Tag
2linkme
A1?Webmarks
Add.io
Adfty
Adifni
All My Faves
Amazon
Amen Me!
AOL Mail
Arto
Aviary Capture
Baang
Baidu
Bebo
Bentio
BiggerPockets
Bit.ly
BizSugar
Bleetbox
Blinklist
Blip
Blogger
Bloggy
Blogmarks
Blogtrottr
Blurpalicious
Boardlite
Bobrdobr
BonzoBox
Bookmarked
Bookmarky.cz
Bookmerken
Bordom
Box.net
Brainify
Bryderi.se
BuddyMarks
Buzzzy
Camyoo
Care2
Chiq
Cirip
CiteULike
ClassicalPlace
Clickazoo
clp.ly
Cndig
Colivia.de
Communicate
Connotea
COSMiQ
Delicious
DesignBump
Designmoo
DigaCultura
Digg
Diggita
Diglog
Digo
DigThisHost
Digzign
Diigo
Dipdive
DoMelhor
Dosti
DotNetKicks
DotShare
Douban
Drimio
Dropjack
Dwellicious
Dzone
Edelight
EFactor
eKudos
elefanta.pl
Email App
Embarkons
euCliquei
Evernote
extraplay
EzySpot
Fabulously40
Fark
Farkinda
Fashiolista
Fashion BURNER
FAVable
Faves
favlog
Favoriten
Favorites
Favoritus
Flaker
Floss.pro
Folkd
forceindya
FreeDictionary
Fresqui
FriendFeed
Friendster
funP
fwisp
Gabbr
Gacetilla
Gamekicker
GiveALink
GlobalGrind
Gmail
Good Noows
Google Buzz
Google Reader
Gravee
GreaterDebater
Grono.net
Grumper
Haber.gen.tr
Hacker News
Hadash Hot
Hatena
Hazarkor
Healthimize
Hedgehogs
HelloTxt
Hipstr
Hitmarks
Hot Bookmark
Hotklix
Hotmail
HTML Validator
Hyves
ideaREF!
Identi.ca
ihavegot
Informazione
Instapaper
iOrbix
iSociety
iWiW
Jamespot
Jisko
JoliPrint
Kaboodle
Kaevur
Kipup
KiRTSY
Kledy
Kommenting
La tafanera
Laaikit
Ladenzeile
Librerio
Lifestream
Link Ninja
Link-a-Gogo
Links Gutter
Linkuj.cz
Livefavoris
LiveJournal
LockerBlogger
Logger24
Lynki
Mail.ru
Markme
Mashbord
Mawindo
Meccho
meinVZ
Mekusharim
Memori.ru
Menéame
Messenger
Mindbodygreen
Mister Wong
Mixx
Moemesto.ru
mototagz
mRcNEtwORK
Multiply
myAOL
Mylinkvault
Myspace
N4G
NetLog
Netvibes
Netvouz
NewsMeBack
NewsTrust
Newsvine
Nujij
OKNOtizie
Oneview
OnGoBee
Orkut
Osmosus
Oyyla
Packg
Pafnet
PDF Online
PDFmyURL
PhoneFavs
PimpThisBlog
Ping.fm
Planypus
Plaxo
Plurk
Pochval
PopEdition
Posteezy
Posterous
Prati.ba
PrintFriendly
Pusha
QRF.in
Quantcast
Qzone
Read It Later
receeve.it
Rediff MyPage
RedKum
RideFix
Scoop.at
Segnalo
Sekoman
Select2Gether
Shaveh
She Told Me
ShirIntarIn
Simpy
Sina Weibo
Slashdot
SMI
SodaHead
Sonico
Speedtile
Sphinn
SpinSnap
Spoken To You
sportpost
springpad
Spruzer
Squidoo
Startaid
Startlap
StoryFollower
studiVZ
Stuffpit
StumbleUpon
Stumpedia
Stylehive
Surfpeople
Svejo
Symbaloo
TagMarks.de
Tagvn
Tagza
Tarpipe
TellMyPolitician
The Web Blend
Thinkfinity
ThisNext
Throwpile
Tip'd
TopSiteler
Transferr
Translate
Tulinq
Tumblr
Tusul
Tvinx
TweetMeme
TwitThis
Typepad
Urlaubswerk
Viadeo
Virb
VisitezMonSite
VKontakte
VybraliSME
Vyoom
Webnews
Whois Lookup
Windy Citizen
WireFan
WordPress
Worio
Wykop
Xanga
Y! Bookmarks
Y! Buzz
Y! Mail
Yammer
Yardbarker
Yemle
Yigg
Yoolink
Yorumcuyum
Youblr
Youbookmarks
YouMob
Yuuby
Zakladok.net
Zanatic
ZicZac
ZooLoo
Zootool
Sending message...
AddThis for Firefox Make sharing easier with AddThis for Firefox.
Download
Don't show these
255 character limit
More:
Get AddThis for Firefox Privacy AddThis
Bookmark & Share X
Make sharing easier with AddThis for Firefox.
Don't show these
Myspace
Favorites
Digg
Delicious
StumbleUpon
Messenger
More... (322)
Get AddThis for Firefox Privacy
查看更多关于设置Mysql数据库的默认编码为utf8的详细内容...