《Mysql學習ubuntu12.04 eclipse mysql中文亂碼的解決方法》要點:
本文介紹了Mysql學習ubuntu12.04 eclipse mysql中文亂碼的解決方法,希望對您有用。如果有疑問,可以聯(lián)系我們。
MYSQL學習在/etc/my.cnf文件中,添加兩行內(nèi)容:
?
MYSQL學習[client]
default-character-set=utf8
MYSQL學習[mysqld]
default-character-set=utf8
MYSQL學習注意:這個文件不必定存在,需要將安裝目錄下 /MYSQL_HOME/support-files/my-medium.cnf 復制到/etc/下,重命名
MYSQL學習修改完之后,必要重啟mysql服務(wù)
停用:
sudo /usr/local/mysql/bin/mysqladmin shutdown
啟用:
sudo /usr/local/mysql/bin/mysql_safe -user=mysql &
MYSQL學習我的重啟命令是:
?
MYSQL學習查看mysql編碼
重啟mysql服務(wù)后
?
MYSQL學習因為我的電腦命令進行了配置:在 vim ~/.bashrc最下面增加了一下一行:
?
MYSQL學習想要讓配置文件馬上生效,需在終端執(zhí)行:
source ~/.bashrc
所以,開啟mysql,只需輸入:mysql,然后輸入暗碼.
?
MYSQL學習mysql>show variables like 'character%';
MYSQL學習+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
MYSQL學習注意,如此修改后,原先所建數(shù)據(jù)庫似乎不克不及用(不確定),盡量備份.
新建數(shù)據(jù)庫,就不會有亂碼了.
《Mysql學習ubuntu12.04 eclipse mysql中文亂碼的解決方法》是否對您有啟發(fā),歡迎查看更多與《Mysql學習ubuntu12.04 eclipse mysql中文亂碼的解決方法》相關(guān)教程,學精學透。維易PHP學院為您提供精彩教程。
轉(zhuǎn)載請注明本頁網(wǎng)址:
http://www.snjht.com/jiaocheng/12730.html