mac安装mysql

首先前往http://www.mysql.com/downloads/mysql/下载mysql
一路安装，安装完成后，

重启mysql-server

sudo /usr/local/mysql/support-files/mysql.server restart

添加快捷命令，用mysql代替/usr/local/mysql/bin/mysql

vi ~/.bash_profile
#mysql
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin

修改密码

mysql -u root -p
默认密码为空
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

修改默认字符集为utf8

cd /usr/local/mysql
vi my.cnf

在打开的文件中添加或修改为以下内容

[client]
 default-character-set=utf8
[mysql]
 default-character-set=utf8
[mysqld]
 character-set-server=utf8

重启mysql-server

sudo /usr/local/mysql/support-files/mysql.server restart

mysql -u root -p
输入密码后进入控制台

创建数据库

mysql>create database taomiao

#切换到项目数据库
use taomiao
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';

Paste_Image.png

查看编码，完全统一了。