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

Source: Internet
Author: User

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. *


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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.