使用命令来查看openstack数据库

最新推荐文章于 2023-02-14 12:44:33 发布

lantianjialiang

最新推荐文章于 2023-02-14 12:44:33 发布

阅读量1.2k

点赞数

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/lantianjialiang/article/details/117354663

版权

# mysql -uroot
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| aodh               |
| cinder             |
| glance             |
| gnocchi            |
| information_schema |
| keystone           |
| mysql              |
| neutron            |
| nova               |
| nova_api           |
| nova_cell0         |
| nova_placement     |
| performance_schema |
| test               |
+--------------------+
MariaDB [keystone]> show tables;
+------------------------------------+
| Tables_in_keystone                 |
+------------------------------------+
| access_rule                        |
| access_token                       |
| application_credential             |
| application_credential_access_rule |
| application_credential_role        |
| assignment                         |
| config_register                    |
| consumer                           |
| credential                         |
| endpoint                           |
| endpoint_group                     |
| federated_user                     |
| federation_protocol                |
| group                              |
| id_mapping                         |
| identity_provider                  |
| idp_remote_ids                     |
| implied_role                       |
| limit                              |
| local_user                         |
| mapping                            |
| migrate_version                    |
| nonlocal_user                      |
| password                           |
| policy                             |
| policy_association                 |
| project                            |
| project_endpoint                   |
| project_endpoint_group             |
| project_tag                        |
| region                             |
| registered_limit                   |
| request_token                      |
| revocation_event                   |
| role                               |
| sensitive_config                   |
| service                            |
| service_provider                   |
| system_assignment                  |
| token                              |
| trust                              |
| trust_role                         |
| user                               |
| user_group_membership              |
| user_option                        |
| whitelisted_config                 |
+------------------------------------+
46 rows in set (0.001 sec)

MariaDB [keystone]> select * from service;
+----------------------------------+--------------+---------+---------------------------------------------------------------------+
| id                               | type         | enabled | extra                                                               |
+----------------------------------+--------------+---------+---------------------------------------------------------------------+
| 3246c3be01c843b1b040a586814c28d7 | compute      |       1 | {"description": "Openstack Compute Service", "name": "nova"}        |
| 3a3f18b1e6f24b589a65339176474d47 | placement    |       1 | {"description": "Openstack Placement Service", "name": "placement"} |
| 46c3aea69cce41a3970afffc5236d13a | metering     |       1 | {"description": "Openstack Metering Service", "name": "ceilometer"} |
| 51d65078ea3d49de9c51ba743b275bec | identity     |       1 | {"description": "OpenStack Identity Service", "name": "keystone"}   |
| 53705ed100f04256a085ec3d66d20c2d | network      |       1 | {"description": "Neutron Networking Service", "name": "neutron"}    |
| 64f1d67948da495ea028ae5d1b233996 | object-store |       1 | {"description": "Openstack Object-Store Service", "name": "swift"}  |
| 7242f43a9d2e4e74a2f8bf181e2b20a4 | metric       |       1 | {"description": "OpenStack Metric Service", "name": "gnocchi"}      |
| 856e0eaef3be4ff7a2130059545ad391 | volumev3     |       1 | {"description": "Cinder Service v3", "name": "cinderv3"}            |
| aa053d467e404c199f037b9cd27342fe | volumev2     |       1 | {"description": "Cinder Service v2", "name": "cinderv2"}            |
| bc7d001430c44d4f965a2f564133c059 | image        |       1 | {"description": "OpenStack Image Service", "name": "glance"}        |
| ff66e1491265443faca79deb445f2133 | alarming     |       1 | {"description": "OpenStack Alarming Service", "name": "aodh"}       |
+----------------------------------+--------------+---------+---------------------------------------------------------------------+
11 rows in set (0.000 sec)