mac terminal mysql

1. 使用时需要找到mysql所在的bin目录

tianqingsedengyanyu:~ fengfeng$ /usr/local/mysql/bin/mysql -u root -p
Enter password: 

2. alias

tianqingsedengyanyu:~ fengfeng$ vim ~/.bash_profile

# Add environment variable COCOS_CONSOLE_ROOT for cocos2d-x
export COCOS_CONSOLE_ROOT=/Applications/Cocos/Cocos2d-x/cocos2d-x-3.10/tools/cocos2d-console/bin
export PATH=$COCOS_CONSOLE_ROOT:$PATH
# Add environment variable COCOS_X_ROOT for cocos2d-x
export COCOS_X_ROOT=/Applications/Cocos/Cocos2d-x
export PATH=$COCOS_X_ROOT:$PATH
# Add environment variable COCOS_TEMPLATES_ROOT for cocos2d-x
export COCOS_TEMPLATES_ROOT=/Applications/Cocos/Cocos2d-x/cocos2d-x-3.10/templates
export PATH=$COCOS_TEMPLATES_ROOT:$PATH
alias mysql='/usr/local/mysql/bin/mysql';
~                                                                               
~                                                                               
~                                                                               
~                                                                               
~                                                                               
~                                                                               
~                                                                               
:wq!

更改别名后 使用下面命令，使 ~/.bash_profile 生效

tianqingsedengyanyu:~ fengfeng$ source  ~/.bash_profile

tianqingsedengyanyu:~ fengfeng$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 64
Server version: 5.7.16 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> 

3. 退出mysql

mysql> quit
Bye
tianqingsedengyanyu:~ fengfeng$ 

4. 开启、终止 mysql 服务

tianqingsedengyanyu:~ fengfeng$ sudo /usr/local/mysql/support-files/mysql.server start
Password:
Starting MySQL
. SUCCESS! 
tianqingsedengyanyu:~ fengfeng$

tianqingsedengyanyu:~ fengfeng$ sudo /usr/local/mysql/support-files/mysql.server stop
Shutting down MySQL
. SUCCESS! 
tianqingsedengyanyu:~ fengfeng$ 

5. 重置密码

mysql> set password = password('123456');

6. 选择数据库

mysql> use eshop;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> 

7. 查看数据库中的表

mysql> show tables;

8. 查看表字段名注释

mysql> desc eshop_points_order;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| point_orderid        | int(11)      | NO   | PRI | NULL    | auto_increment |
| point_ordersn        | varchar(20)  | NO   |     | NULL    |                |
| point_buyerid        | int(11)      | NO   |     | NULL    |                |
| point_buyername      | varchar(50)  | NO   |     | NULL    |                |
| point_buyeremail     | varchar(100) | NO   |     | NULL    |                |
| point_addtime        | int(11)      | NO   |     | NULL    |                |
| point_shippingtime   | int(11)      | YES  |     | NULL    |                |
| point_shippingcode   | varchar(50)  | YES  |     | NULL    |                |
| point_shipping_ecode | varchar(30)  | YES  |     | NULL    |                |
| point_finnshedtime   | int(11)      | YES  |     | NULL    |                |
| point_allpoint       | int(11)      | NO   |     | 0       |                |
| point_ordermessage   | varchar(300) | YES  |     | NULL    |                |
| point_orderstate     | int(11)      | NO   |     | 20      |                |
+----------------------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql> 

---

 不定期更新 不合适的地方 还请指点~ 感激不尽