Mac 安装mysql问题

如果你是Mac，那记得是要在官网下载DMG Archive的安装包。另外，需要注意，MySQL安装成功之后会弹出提示框，给出了root用户的临时密码，这个密码一定要记住。

弹窗的内容如下：

2017-06-27T05:38:39.060347Z 1 [Note] A temporary password is generated for root@localhost: p0f*t<YfeDtr

If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.

这个初始密码用于第一次登陆用。

MySQL安装完之后，在系统偏好设置里，就会多出一项MySQL的设置，打开后就会出现如下界面：

开启mysql。

打开终端，输入：

$ mysql -u root -p

回车，输入刚才的初始密码，可以看到成功连接mysql

Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 200
Server version: 5.7.18

Copyright (c) 2000, 2017, 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> 

但此时做任何操作都会出现如下错误：

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

意思是让你赶紧设置密码，初始密码只是用于第一次登陆的。
通过

mysql> SET PASSWORD = PASSWORD('你的密码');

设置密码后，就可以正常使用mysql了。

mysql> \q
Bye
$ mysql -u root -p
Enter password: 

推出重新登录，输入刚设置的密码。

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 229
Server version: 5.7.18 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, 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> 

成功连接！
接下开酒可以创建自己的表了～

mysql> create database db1;
Query OK, 1 row affected (0.00 sec)