mac OS 10.11 安装mysql的记录

何5290

在Mac OS X10.11安装MySQL(mysql-5.7.10-osx10.10-x86_64.dmg)
　　1、现在官网下载mysql的dmg文件－－mysql-5.7.10-osx10.10-x86_64.dmg，一路默认安装，在安装类型这一步时点击自定义，把其中的四项全部选中，然后完成安装,安装完成时，会有一个root@localhost的临时密码。
　　2、打开终端，输入 ps -ef|grep mysql看mysql进程是否存在，如果存在，则可以进行以下操作，

localhost:mysql zhengjj$ /usr/local/mysql/bin/mysql -uroot -p'j41I6Fh%uY6u'

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

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

Your MySQL connection id is 5

Server version: 5.7.10

 

Copyright (c) 2000, 2015, 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> alter user root@'localhost' identified by '123456';

Query OK, 0 rows affected (0.41 sec)

 

mysql> flush privileges;

Query OK, 0 rows affected (0.34 sec)

 

mysql>
 
用另一个终端登陆操作：
　　/usr/local/mysql/bin/mysql -uroot -p123456
//----------------------------------------------------------------------
Mac下Mysql的设置，最新版的10.11+5.6.27
　　http://flashing.iyunv.com/blog/2249631
　　
　　http://yangjunwei.com/a/1378.html 
　　Mac OS X Mavericks 配置 Apache+Mysql+PHP 详细教程
　　
　　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.*