Mac下使用mysql

標籤：mysql

1. 安裝mysql

2. 在喜好設定中啟動 mysql 服務

3. 開啟終端  輸入  mysql  ， 會發現

chenhong:~ chenhong$ mysql-bash: mysql: command not found

4. 設定mysql 命令，輸入    

1)alias mysql=/usr/local/mysql/bin/mysql

2)alias mysqladmin=/usr/local/mysql/bin/mysqladmin

再次輸入 mysql 命令會發現

chenhong:~ chenhong$ mysql-bash: mysql: command not foundchenhong:~ chenhong$ alias mysql=/usr/local/mysql/bin/mysqlchenhong:~ chenhong$ alias mysqladmin=/usr/local/mysql/bin/mysqladminchenhong:~ chenhong$ mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 36Server version: 5.1.63-log MySQL Community Server (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> 

5. 使用資料庫 , 出現 mysql Access denied for user [email protected]錯誤

mysql Access denied for user [email protected]錯誤

是由於登陸帳號的許可權問題，因此，用最高許可權登陸（安裝mysql時候設定的使用者名稱和密碼）

$ mysql -u root -p

然後控制台會提示你輸入密碼

chenhong:~ chenhong$ mysql -u root -pEnter password: 

輸入密碼後,就可以使用資料庫

mysql> use micro_messageDatabase changed

Mac下使用mysql