OSX completely deletes MySQL and how to make MySQL support Chinese _ MySQL

OSX deletes MySQL completely and how to make MySQL support Chinese characters OSX completely deletes MySQL and how to make MySQL support Chinese _ MySQL

You can see this article on my new page.

Recently I installed the latest MySQL version on OSX and studied it. for example, Chinese garbled characters and full uninstallation problems often occur in the past, so thanks for having nothing to do today. it will be convenient to check it later, even though I have already put it in my Evernote.

Fully uninstall MySQL For OSX

Stop all MySQL-related processes first:

    sudo rm /usr/local/mysql        sudo rm -rf /usr/local/mysql*        sudo rm -rf /Library/StartupItems/MySQLCOM        sudo rm -rf /Library/PreferencePanes/My*        vim /etc/hostconfig and removed the line MYSQLCOM=-YES-        rm -rf ~/Library/PreferencePanes/My*    sudo rm -rf /Library/Receipts/mysql*        sudo rm -rf /Library/Receipts/MySQL*    sudo rm -rf /var/db/receipts/com.mysql.*

Over.

Set Chinese support

The preparation method is as follows:
1. copy any *. cnf file under/usr/local/mysql/support-files to/etc/my. cnf

1. Add default-character-set = utf8 next to the [client] of the my. cnf file.

2. Add the following three sentences after [mysqld:

    default-storage-engine=INNODB character-set-server=utf8 collation-server=utf8_general_ci

3. Save and exit. reboot MySQL is ready.
   Above.

The above section describes how to completely delete MySQL from OSX and enable MySQL to support Chinese _ MySQL. For more information, see PHP Chinese website (www.php1.cn )!