# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1449851450 -7200
# Node ID 072cc8a704ceda9efc459930ab8d3b10107f282c
# Parent  752c192306ffea52dc2d4bd12493c90bef4f4e5f
List databases, tables, columns.

diff -r 752c192306ff -r 072cc8a704ce mysql.rst
--- a/mysql.rst	Fri Dec 11 18:11:50 2015 +0200
+++ b/mysql.rst	Fri Dec 11 18:30:50 2015 +0200
@@ -33,3 +33,29 @@
   $ mycli -u $USER
   Password:         <== Type password.
 
+List databases, tables, columns.
+================================
+::
+
+  $ mysql -u $USER -p
+  Enter password:   <== Type password.
+
+  SHOW DATABASES;
+
+  USE mysql;
+  MariaDB [mysql]> SHOW TABLES;
+
+  MariaDB [mysql]> SHOW COLUMNS FROM user;
+
+  MariaDB [mysql]> DESCRIBE user;
+
+  MariaDB [mysql]> SHOW STATUS;
+
+  MariaDB [mysql]> SHOW CREATE DATABASE mysql;
+  MariaDB [mysql]> SHOW CREATE TABLE user;
+
+  MariaDB [mysql]> SHOW GRANTS;
+
+  MariaDB [mysql]> SHOW WARNINGS;
+  MariaDB [mysql]> SHOW ERRORS;
+