lovedeMac:bin love$ pwd /usr/local/mysql/bin vim ~/.bash_profile =============================== PATH=$PATH:/usr/local/mysql/bin =============================== source ~/.bash_profile mysqladmin -u root -p password 123456 mysql -u root -p rm -rf /usr/local/mysql rm -rf /usr/local/mysql* rm -rf /Library/StartupItems/MySQLCOM rm -rf /Library/PreferencePanes/My* vim /etc/hostconfig (and removed the line MYSQLCOM=-YES-) rm -rf ~/Library/PreferencePanes/My* rm -rf /Library/Receipts/mysql* rm -rf /Library/Receipts/MySQL* rm -rf /var/db/receipts/com.mysql.* CREATE DATABASE IF NOT EXISTS bookshop DEFAULT CHARSET utf8 COLLATE utf8_general_ci; sh-3.2# pwd /etc sh-3.2# vi my.cnf ======================== [mysqld] [client] default-character-set=utf8 [mysqld] collation-server = utf8_unicode_ci init-connect=‘SET NAMES utf8‘ character-set-server = utf8 [mysql] default-character-set=utf8 ========================