Enter password: ************
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.7-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> show tables;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test           |
+----------------+
1 row in set (0.00 sec)

MariaDB [test]> select * from test;
+----+----------------------------------+---------------------+
| ID | Name                             | Time                |
+----+----------------------------------+---------------------+
|  1 | Test                             | 2015-10-10 12:15:36 |
|  2 | Row 2                            | 2015-10-10 12:15:45 |
|  3 | This could be a good chance.     | 2015-10-10 12:17:04 |
|  4 | The function is deprecated here. | 2015-10-10 12:17:38 |
+----+----------------------------------+---------------------+
4 rows in set (0.00 sec)

MariaDB [test]> select * from test;
+----+-----------------------------------------------+---------------------+
| ID | Name                                          | Time                |
+----+-----------------------------------------------+---------------------+
|  1 | Test                                          | 2015-10-10 12:15:36 |
|  2 | Row 2                                         | 2015-10-10 12:15:45 |
|  3 | This could be a good chance.                  | 2015-10-10 12:17:04 |
|  4 | The function is deprecated here.              | 2015-10-10 12:17:38 |
|  5 | But those features are currently unavailable. | 2015-10-10 12:19:07 |
+----+-----------------------------------------------+---------------------+
5 rows in set (0.00 sec)

MariaDB [test]>

MariaDB自帶了一個名叫HeidiSQL的管理工具。

MariaDB [test]> exit
Bye

C:\Program Files\MariaDB 10.1\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)

C:\Program Files\MariaDB 10.1\bin>