mac下mysql

如果你brew install mysql 之后出现问题要卸载：

brew remove mysql
brew cleanup
launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
rm ~/Library/LaunchAgents/com.mysql.mysqld.plist
 
sudo rm -rf /usr/local/var/mysql

然后重新开始

installed mysql with brew install mysql
ran the commands brew suggested:

unset TMPDIR

mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Start mysql with mysql.server command, to be able to log on it

Used the alternate security script:

/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation
Followed the launchctl section from the brew package script output

Boom.

启动MYSQL

mysql.server start

初始化root

 USE mysql ;
 set password for root@localhost = password('123456');

新建用户

脚本：CREATE USER 'username'@'host' [IDENTIFIED BY 'PASSWORD'] 其中密码是可选项；

例子：CREATE USER 'john'@'192.168.189.71' IDENTIFIED BY "123";

CREATE USER 'john'@'192.168.189.%' IDENTIFIED BY "123";

CREATE USER 'john'@'%' ;

最好重启或者刷新一下数据库

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

1.#ps -A|grep mysql 
   显示类似：
  1829 ?        00:00:00 mysqld_safe
   1876 ?        00:00:31 mysqld
  2.#kill -9 1829
  3.#kill -9 1876
  4.#/etc/init.d/mysql restart
  5.#mysql -u root -p