记录mysql for mac

http://blog.iblack7.com/linux/configure-mysql-in-mac-os-x/

设置环境变量： 通过运行“sudo vi /etc/bashrc”，在bash配置文件中加入mysqlstart、mysql和mysqladmin的别名（注意：修改完毕之后需要退出“终端（Terminal）”之后重新进入，这些命令才会生效）：

#mysql
alias mysqlstart='sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart'
alias mysql='/usr/local/mysql/bin/mysql'
alias mysqladmin='/usr/local/mysql/bin/mysqladmin'

从终端启动/停止 mysql

启动：sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
停止：sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
重启：sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart
修改默认密码：mysqladmin -u root password '要设置的密码'
终端登陆mysql:mysql -u root -p

$ mysql -u root -p

输入密码,then

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE
    -> ON *.*   //for all tables in DATABASE database
    -> TO 'user'@'localhost'
    -> IDENTIFIED BY 'password';

mysql> FLUSH PRIVILEGES;  //生效授权

参考：http://2484055.blog.51cto.com/2474055/1335382

http://stackoverflow.com/questions/18523861/error-1364-1364-field-ssl-cipher-doesnt-have-a-default-value

http://blog.csdn.net/fly0744/article/details/8889586