OSX deletes MySQL completely and How to Make MySQL support Chinese Characters

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.