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