mysql>show databases;+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| yuanqk |
| yuanqk_gbk |
| yuanqk_utf8 |
+--------------------+
7 rows in set (0.00sec)
mysql>
yuanqk、yuanqk_gbk\utf8是我刚才创建的数据库,到操作系统上看看都创建了哪些东西,我的数据存放目录在/data/3306/data下
[root@mysql data]# pwd
/data/3306/data
[root@mysql data]# ls -lrt
total 141336
drwx------. 2 mysql mysql 4096 May 17 23:32 test
drwx------. 2 mysql mysql 4096 May 17 23:32 performance_schema
drwx------. 2 mysql mysql 4096 May 17 23:32 mysql
-rw-rw----. 1 mysql mysql 5242880 May 17 23:35 ib_logfile1
-rw-rw----. 1 mysql mysql 134217728 May 18 19:38 ibdata1
-rw-rw----. 1 mysql mysql 5242880 May 19 10:40 ib_logfile0
drwx------. 2 mysql mysql 4096 May 19 10:53 yuanqk <===对应的三个目录
drwx------. 2 mysql mysql 4096 May 19 10:58 yuanqk_gbk <===对应的三个目录
drwx------. 2 mysql mysql 4096 May 19 11:03 yuanqk_utf8 <===对应的三个目录
[root@mysql data]# cd yuanqk
[root@mysql yuanqk]# ls -l
total 4
-rw-rw----. 1 mysql mysql 65 May 19 10:53 db.opt <===这个应该就是数据文件了
[root@mysql yuanqk]# cd ../yuanqk_gbk/
[root@mysql yuanqk_gbk]# ls -l
total 4
-rw-rw----. 1 mysql mysql 59 May 19 10:58 db.opt
[root@mysql yuanqk_gbk]#
----------------显示有哪些表------------
mysql> show tables;
Empty set (0.00 sec) <===显示是空的,因为还没连接到数据库中,不过可以使用from或in关键字来显示其他数据库的信息
mysql> show tables from mysql;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
24 rows in set (0.00 sec)
mysql>
mysql>
mysql> show tables in mysql;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
24 rows in set (0.00 sec)
mysql>
也可以使用use连接到数据库后,再使用show命令,show有很多命令,可以通过help show查看