mac下安裝並配置mysql

標籤：

1、下載以.dmg結尾mysql安裝包

mysql：http://dev.mysql.com/downloads/mysql/

安裝過程中，會有一個彈窗提示，注意：XXX的位置是你的初始登入密碼

2016-08-17T15:58:04.890314Z 1 [Note] A temporary password is generated for [email protected]: XXX

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

 

2、安裝完成之後，設定系統變數，

vim /etc/profile 

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

 

3、開啟電腦-》系統喜好設定-》Start MySQL Server

啟動服務

 

4、發現登入之後，查詢命令輸入無用，

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

bash-3.2# mysql -u root -p

Enter password: XXX（初始登入密碼）

ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)

bash-3.2# mysql -u root -p

Enter password: 

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

Your MySQL connection id is 2538

Server version: 5.7.14

 

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> show databases;

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

mysql> select version(),current_date;

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

 

5、所以你必須重設登入密碼

mysql> SET PASSWORD = PASSWORD(‘你自己設定的密碼‘);
Query OK, 0 rows affected, 1 warning (0.03 sec)

mysql> ALTER USER ‘root‘@‘localhost‘ PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.03 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

　

　　

 

 

 

 

mac下安裝並配置mysql