今天在mac上瞎折腾时,把mysql玩坏了,想卸载重装,却发现找不到卸载程序,百度了下,将操作步骤备份于此:
cd ~/sudo rm/usr/local/mysql
sudo rm -rf /usr/local/var/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.*
我安装的版本是5.6.25社区版
注:重装好以后,建议将机器重启一下,否则有可能启动失败,或者只能以安全模式启动(我重装了二遍才发现,有可能是我笔记本的个别现象)
值得一提的是:mysql默认的编码不是utf8,因此中文内容insert到db后,变成乱码,解决办法:
先停掉mysql,然后
sudo vi /usr/local/mysql/my.cnf 找到[client]及[mysqld]节点,参考下面的内容指定编码
[client]
default-character-set=utf8
[mysqld]
character_set_server=utf8</