mysql常见命令

1. cmd进入mysql

先进入安装的bin目录，输入mysql -p端口 -u用户名 -p密码

status查询数据的基本参数

C:\>cd C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin
C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysql -p3306 -uroot -proot
mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.27, for Win32 (AMD64)

Connection id:          11
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.7.27-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Uptime:                 23 min 2 sec

Threads: 5  Questions: 340  Slow queries: 0  Opens: 129  Flush tables: 1  Open t
ables: 122  Queries per second avg: 0.246
--------------

2. 查询编码和设置编码

mysql> show variables like '%char%';
+--------------------------+----------------------------------------------------
-----------+
| Variable_name            | Value
           |
+--------------------------+----------------------------------------------------
-----------+
| character_set_client     | gbk
           |
| character_set_connection | gbk
           |
| character_set_database   | latin1
           |
| character_set_filesystem | binary
           |
| character_set_results    | gbk
           |
| character_set_server     | latin1
           |
| character_set_system     | utf8
           |
| character_sets_dir       | C:\Program Files (x86)\MySQL\MySQL Server 5.7\share
\charsets\ |
+--------------------------+----------------------------------------------------
-----------+

 设置编码

set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;

3. 查询当前日期： 

mysql> select current_date();
+----------------+
| current_date() |
+----------------+
| 2019-09-22     |
+----------------+
1 row in set (0.00 sec)

4.创建数据库

CREATE SCHEMA SpringBootLearn; 

查询数据，需要选择schema（否则报错：ERROR 1046 (3D000): No database selected）

use springbootlearn

或者在表名前加上schema的名称，如：select * from springbootlearn.t_user; 

紧接着可以开始对该数据库的表数据进行操作了。 

5.添加用户

参考：Mysql添加用户，给用户授权