How to login MYSQL

$ mysql -uroot -p<password>

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cinder             |
| glance             |
| heat               |
| keystone           |
| mysql              |
| nova               |
| performance_schema |
+--------------------+
8 rows in set (0.14 sec)

mysql> use keystone
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
+-----------------------+
| Tables_in_keystone    |
+-----------------------+
| assignment            |
| credential            |
| domain                |
| endpoint              |
| group                 |
| migrate_version       |
| policy                |
| project               |
| region                |
| role                  |
| service               |
| token                 |
| trust                 |
| trust_role            |
| user                  |
| user_group_membership |
+-----------------------+
16 rows in set (0.00 sec)

mysql> select name from user;
+-------------------+
| name              |
+-------------------+
| heat_domain_admin |
| admin             |
| alt_demo          |
| cinder            |
| demo              |
| glance            |
| heat              |
| nova              |
| sanu              |
+-------------------+
9 rows in set (0.00 sec)

mysql> select name from project;
+--------------------+
| name               |
+--------------------+
| admin              |
| alt_demo           |
| demo               |
| invisible_to_admin |
| service            |
+--------------------+
5 rows in set (0.00 sec)

mysql> desc endpoint;
+--------------------+--------------+------+-----+---------+-------+
| Field              | Type         | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| id                 | varchar(64)  | NO   | PRI | NULL    |       |
| legacy_endpoint_id | varchar(64)  | YES  |     | NULL    |       |
| interface          | varchar(8)   | NO   |     | NULL    |       |
| region             | varchar(255) | YES  |     | NULL    |       |
| service_id         | varchar(64)  | NO   | MUL | NULL    |       |
| url                | text         | NO   |     | NULL    |       |
| extra              | text         | YES  |     | NULL    |       |
| enabled            | tinyint(1)   | NO   |     | 1       |       |
+--------------------+--------------+------+-----+---------+-------+
8 rows in set (0.11 sec)

mysql> select s.type,e.url from service as s,endpoint  as e where s.id=e.service_id;