Mysql数据库管理

1.查看数据库版本命令：

1.1   status

MySQL> status--------------C:/PRogram Files/MySQL/MySQL Server 5.6/bin/mysql.exe  Ver 14.14 Distrib 5.6.24, for Win64 (x86_64)Connection id:          1Current database:Current user:           root@localhostSSL:                    Not in useUsing delimiter:        ;Server version:         5.6.24-log MySQL Community Server (GPL)Protocol version:       10Connection:             localhost via TCP/ipServer characterset:    utf8Db     characterset:    utf8Client characterset:    utf8Conn.  characterset:    utf8TCP port:               3306Uptime:                 8 min 49 secThreads: 1  Questions: 12  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.022--------------

1.2    mysql --help | grep Distrib

mysql>  mysql --help | grep Distrib;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'mysql --help | grep Distrib' at line 1mysql>

1.3select version();

mysql> select version();+------------+| version()  |+------------+| 5.6.24-log |+------------+1 row in set (0.00 sec)