停用命令：sudo mysqladmin shutdown -u root -p

啟用命令：sudo /etc/init.d/mysql restart

           或者：sudo mysqld_safe -user=mysql &3.查看現在mysql的編碼進入mysql命令：sudo mysql －u root -p

檢查mysql字符集命令：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/ | +--------------------------+----------------------------+

4.原來建的庫和表似乎都無法生效，不過新建的則可以正常顯示中文！

注意：

如果不能啟動，錯誤日志為：/usr/bin/mysqld: unknown variable 'default-character-set=utf8'

通過rpm包的方式安裝了MySQL-server-5.5.11，直接在命令行輸入service mysql start，啟動mysql成功，

然后修改/etc/my.cnf，給[mysqld]下增加了default-character-set=utf8，再重啟mysql服務，這時候報錯：

Starting MySQL............The server quit without updating PID file (/var/lib/mysql/node1.pid). [faild]

查看日志/var/log/mysql.log，發現其中提示：

/usr/bin/mysqld: unknown variable 'default-character-set=utf8'

看來是 default-character-set=utf8這個設置項惹得禍....

在網上搜索一番，發現有人提出，用character_set_server=utf8來取代 default-character-set=utf8   能解決這個問題，

試了試，換掉 character_set_server=utf8， 再啟動果然沒問題了...