安装MySQL的一些问题:
安装版本:
Mac OS X 10.9 (x86, 64-bit), DMG Archive 5.6.24 167.6M
(mysql-5.6.24-osx10.9-x86_64.dmg)
下载地址:http://dev.mysql.com/downloads/mysql/
(1)自定义命令alias:
vim ~/.bashrc
添加两行记录:
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
source ~/.bashrc
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
source ~/.bashrc
(2)密码问题
在创建数据库时,如果没有设置密码,可能会出现的问题,更改mysql root账户密码就可以解决这个问题。
mysql> CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test2'
是因为mysql数据库的user表里,存在用户名为空的账户即匿名账户,导致登录的时候是虽然用的是root,但实际是匿名登录的。
重新设置密码:
mysqladmin -u root password 新密码
再次创建数据库 test2, 成功:
mysql> CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
[OVER]
Reference:
http://www.it165.net/database/html/201408/7795.html
http://www.cnblogs.com/macro-cheng/archive/2011/10/25/mysql-001.html
http://dev.mysql.com/downloads/mysql/
http://www.tuicool.com/articles/3myYrqm