mac 10.10.5 mysql_mysql for Mac 10.10.5安装的一些坑

安装之前，先说下要注意的点：网上有很多资源，不要盲目就去试验，实验之后的结果就是这缺那缺，这调那调，还是没用。建议，先看自己的系统，然后找到和自己系统匹配的教程，mysql 5.6和mysql 5.7，安装之后还有很大的不同，一些文件的修改什么的，文件你都找不到，所以还是要找对资源。

先贴一段彻底卸载mysql的命令：

cd ~/

sudo rm /usr/local/mysql

sudo rm -rf /usr/local/mysql*

sudo rm -rf /Library/StartupItems/MySQLCOM

sudo rm -rf /Library/PreferencePanes/My*

vim /etc/hostconfig and removed the line MYSQLCOM=-YES-rm -rf ~/Library/PreferencePanes/My*

sudo rm -rf /Library/Receipts/mysql*

sudo rm -rf /Library/Receipts/MySQL*

sudo rm -rf /var/db/receipts/com.mysql.*

安装开始

1.现到官网下载mysql，网上有很多教程，建议下载mysql-5.7.11-osx10.9-x86_64.dmg

2.傻瓜式安装以后，会跳出一个窗口告诉你有个临时密码，可记可不记，打开终端，看是不是能启动

lyzdeMacBook-Air:~ lyz$ sudo /usr/local/mysql/support-files/mysql.server start

Password:

Starting MySQL

. SUCCESS!

3.下面先关闭mysql

lyzdeMacBook-Air:~ lyz$sudo /usr/local/mysql/support－files/mysql.server stop

Password:

Shutting down MySQL

.. SUCCESS!

lyzdeMacBook-Air:~ lyz$cd /usr/local/mysql/bin

lyzdeMacBook-Air:bin lyz$sudo su

sh-3.2# ./mysqld_safe --skip-grant-tables &

[1] 742

sh-3.2# 2016-03-16T01:25:23.6NZ mysqld_safe Logging to '/usr/local/mysql/data/lyzdeMacBook-Air.local.err'.

2016-03-16T01:25:23.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

之后，重新打开一个终端窗口，开始修改密码

lyzdeMacBook-Air:~ lyz$ cd /usr/local/mysql/bin

lyzdeMacBook-Air:bin lyz$ ./mysqladmin -u root -p password aaa

Enter password:

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

mysqladmin:

You cannot use 'password' command as mysqld runs

with grant tables disabled (was started with --skip-grant-tables).

Use: "mysqladmin flush-privileges password '*'" instead

lyzdeMacBook-Air:bin lyz$ ./mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

然后重启终端就可以了，只不过还要进入/urs/local/mysql/bin路径下进入

4.接下来再配置下环境变量，你就可以打开终端直接输入命令就可以进入mysql 了

open -e .bash_profile

会跳出一个窗口，你直接在里边加下面这句话，然后保存关闭窗口，再重启终端就可以了

export PATH=/usr/local/mysql/bin:$PATH

重启后直接输入

mysql -uroot -p

然后提示输入数据库密码，输入之前修改的密码，就可以进入了。