mysql
1:在终端下:mysql -V(大写)
//代码
$ mysql -V
mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (i686) using readline 6.3
2:在mysql中:mysql> status;(引号要加)
//代码
进入mysql
1.没有用户的
$ mysql -u root
2.有用户的
$ mysql -u root -p
然后输入用户名和密码
进入之后:
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (i686) using readline 6.3
Connection id: 50
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.46-0ubuntu0.14.04.2 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 7 hours 23 min 47 sec
Threads: 1 Questions: 128 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.004
--------------
mysql>
3:在help里面查找
//代码
$ mysql --help | grep Distrib
mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (i686) using readline 6.3
4:使用mysql的函数
//代码
1进入mysql
方法(见上)
2.命令
mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 5.5.46-0ubuntu0.14.04.2 |
+-------------------------+
1 row in set (0.00 sec)
mysql>