设置Mysql数据库的默认编码为utf8

设置Mysql数据库的默认编码为utf8首页|注册|登录|用户群体|关于我们Rss Feed

Skip navigation.

敏捷开发最佳实践GemDigger问题交流书籍资料职位招聘线下活动

Ruby on Rails 敏捷开发最佳实践分享

分享你的敏捷开发最佳实践，为rails社区的枝繁叶茂做出自己的贡献.

按tags浏览

rails3linuxgrailspassengeractionmailercapistranocontrollerpluginactiverecordtoolssqlregexpdatabaseviewrubyrailsmodeljavascriptsroutesgemconnectiontestdeploymentalgorithmarelproductionexceptiontaskhelperenvironmentcookiesdesign patterni18nnginxpaperclip

按栏目浏览

敏捷开发最佳实践 (53篇) GemDigger (已digger了3个) 问题交流 (15个已解决, 41个待解决) 职位招聘 (已提供20个职位) 书籍资料 (已经提供15本)

推荐书籍

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/f

$ sudo chmod 777 /etc/mysql/f$ vim /etc/mysql/f

在client下面加上：

default-character-set=utf8

在mysqld下面加上：

default-character-set=utf8init_connect='SET NAMES utf8'

保存，退出wq

重启mysql服务：

$sudo /etc/init.d/mysql start

发现出错：

Warning: World-writable config file '/etc/mysql/f' is ignored/usr/bin/mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'luoping'@'localhost' (using password: NO)'

原因为：/etc/mysql/f 权限太高，搜索了一番，有人说许改为600，但是我发觉不行，查看了/etc/mysql/文件夹里的其他文件，权限是755，所以修改权限

$sudo chmod 755 /etc/mysql/f

重启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 楼jerry 回复于 25 天 前

貌似用windows的同学容易有这个数据库默认的编码问题。

0 支持# 2 楼aoner 回复于 20 天 前

windows上更容易点吧，安装的时候有提示，可以自己选择编码，不用像linux安装完了在改配置文件

添加回复

你的大名*

如果你还未注册， 请填写你的名字。

你可以实用以下html标签:

<a href="" title=""> <b> <blockquote> <pre> <code> <em> <i> <strong>

代码块请使用 <pre><code>...</code></pre>.

关于我们线下活动用户群体Rss Feed

All rights resolved by

Bookmark & Share

XSelect from these web-based feed readers:

AOLBloglinesGoogle ReaderMy MSNNetvibesNewsisfreePageflakesYahooNo matching services..netShoutout100zakladok2 Tag2linkmeA1‑WebmarksAdd.ioAdftyAdifniAeroAll My FavesAmazonAmen Me!AOL MailArtoAviaryCaptureBaangBaiduBeboBentioBiggerPocketsBit.BrainifyBryderi.seBuddyMarksBuzzzyCamyooCare2ChiqCiripCiteULikeClassicalPlaceClickazooclp.lyCndigColivia.deCommunicateConnoteaCOSMiQDeliciousDesignBumpDesignmooDigaCulturaDiggDiggitaDiglogDigoDigThisHostDigzignDiigoDipdiveDoMelhorDostiDotNetKicksDotShareDoubanDrimioDropjackDwelliciousDzoneEdelightEFactoreKudoselefanta.plEmailEmail AppEmbarkonseuCliqueiEvernoteextraplayEzySpotFabulously40FacebookFarkFarkindaFashiolistaFashionBURNERFAVableFavesfavlogFavoritenFavoritesFavoritusFlakerFloss.proFolkdFollowTagsforceindyaFreeDictionaryFresquiFriendFeedFriendsterfunPfwispGabbrGacetillaGamekickerGiveALinkGlobalGrindGmailGood NoowsGoogleGoogle GrumperHaber.gen.trHacker NewsHadash HotHatenaHazarkorHealthimizeHedgehogsHelloTxtHipstrHitmarksHot BookmarkHotklixHotmailHTMLValidatorHyvesideaREF!Identi.caihavegotInformazioneInstapaperiOrbixiSocietyiWiWJamespotJiskoJoliPrintJumptagsKaboodleKaevurKipupKiRTSYKledyKommentingLa tafaneraLaaikitLadenzeileLibrerioLifestreamLink NinjaLink-a-GogoLinkedInLinks GutterLinkSharesLinkuj.czLivefavorisLiveJournalLockerBloggerLogger24LynkiMail.ruMarkmeMashbordMawindoMecchomeinVZMekusharimMemori.ruMenéameMessengerMindbodygreenMister WongMixxMoemesto.rumototagzmRcNEtwORKMultiplymyAOLMylinkvaultMyspaceN4GNetLogNetvibesNetvouzNewsMeBackNewsTrustNewsvineNujijOKNOtizieOneviewOnGoBeeOrkutOsmosusOyylaPackgPafnetPDF OnlinePDFmyURLPhoneFavsPimpThisBlogPing.fmPlanypusPlaxoPlurkPochvalPopEditionPosteezyPosterousPrati.baPrintPrintFriendlyPushaQRF.inQuantcastQzoneRead It Laterreceeve.itRedditRediff MyPageRedKumRideFixScoop.atSegnaloSekomanSelect2GetherShavehShe Told MeShirIntarInSimpySina WeiboSlashdotSMISodaHeadSonicoSpeedtileSphinnSpinSnapSpoken To YousportpostspringpadSpruzerSquidooStartaidStartlapStoryFollowerstudiVZStuffpitStumbleUponStumpediaStylehiveSurfpeopleSvejoSymbalooTagMarks.deTagvnTagzaTarpipeTellMyPoliticianThe Web BlendThinkfinityThisNextThrowpileTip'dTopSitelerTransferrTranslateTulinqTumblrTusulTvinxTweetMemeTwitterTwitThisTypepadUrlaubswerkViadeoVirbVisitezMonSiteVKontakteVybraliSMEVyoomWebnewsWhoisLookupWindyCitizenWireFanWordPressWorioWykopXangaXINGY! BookmarksY! BuzzY! ZanaticZicZacZooLooZootoolDoneMessage sent! Share again.

Sending message...

AddThis for Firefox

Make sharing easier with AddThis for Firefox.Download

Don't show theseTo: (email address)From: (email address)Note: (optional)255 character limitMore:Get AddThis for FirefoxPrivacyAddThisBookmark & ShareX

Make sharing easier with AddThis for Firefox.

Don't show theseFacebookTwitterMyspacePrintGoogleFavoritesDiggDeliciousStumbleUponMessengerEmailMore... (322)Get AddThis for FirefoxPrivacyposted on -12-10 13:14lexus 阅读(...) 评论(...) 编辑 收藏