mysql 常用指令

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

mysql> select @@basedir;
+------------------------------------------+
| @@basedir |
+------------------------------------------+
| C:/Program Files/MySQL/MySQL Server 5.5/ |
+------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT system_user(),user();
+----------------+----------------+
| system_user() | user() |
+----------------+----------------+
| root@localhost | root@localhost |
+----------------+----------------+
1 row in set (0.00 sec)

mysql> SELECT user, password FROM mysql.user;
+-----------+-------------------------------------------+
| user | password |
+-----------+-------------------------------------------+
| Worklight | *78A91369E3BAD0CD4B70C348CE2A5BC5E0A70E2D |
| Worklight | *78A91369E3BAD0CD4B70C348CE2A5BC5E0A70E2D |
| root | *21E3F9D13177B74511F2D274F17C92488DC6F4FB |
+-----------+-------------------------------------------+
3 rows in set (0.09 sec)

mysql> SELECT table_schema, table_name FROM information_schema.tables;
+--------------------+----------------------------------------------+
| table_schema | table_name |
+--------------------+----------------------------------------------+
| information_schema | CHARACTER_SETS |
| information_schema | COLLATIONS |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY |
| information_schema | COLUMNS |
| information_schema | COLUMN_PRIVILEGES |
| information_schema | ENGINES |
| information_schema | EVENTS |
| information_schema | FILES |
| information_schema | GLOBAL_STATUS |
| information_schema | GLOBAL_VARIABLES |
| information_schema | KEY_COLUMN_USAGE |

原文地址:https://www.cnblogs.com/vigarbuaa/p/3208882.html