Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.10-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use root;
ERROR 1049 (42000): Unknown database 'root'
mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.45 sec)

mysql> create database openmrs;
Query OK, 1 row affected (0.16 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| openmrs            |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.03 sec)

mysql> ccreate database root;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ccreate database root' at line 1
mysql> create database root;
Query OK, 1 row affected (0.08 sec)

mysql> use root;
Database changed
mysql> show variables like '%port%'
    -> show variables like '%port%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show variables like '%port%'' at line 2
mysql> show variables like %port%;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%port%' at line 1
mysql> show variables like "%port%";
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_support_xa        | ON    |
| large_files_support      | ON    |
| port                     | 3307  |
| report_host              |       |
| report_password          |       |
| report_port              | 3307  |
| report_user              |       |
| require_secure_transport | OFF   |
+--------------------------+-------+
8 rows in set (0.41 sec)

mysql> use openmrs;
Database changed
mysql> show variables like "%port%";
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_support_xa        | ON    |
| large_files_support      | ON    |
| port                     | 3307  |
| report_host              |       |
| report_password          |       |
| report_port              | 3307  |
| report_user              |       |
| require_secure_transport | OFF   |
+--------------------------+-------+
8 rows in set (0.37 sec)

mysql> use openmrs;
Database changed
mysql> show tables;
+--------------------------------+
| Tables_in_openmrs              |
+--------------------------------+
| active_list                    |
| active_list_allergy            |
| active_list_problem            |
| active_list_type               |
| clob_datatype_storage          |
| cohort                         |
| cohort_member                  |
| concept                        |
| concept_answer                 |
| concept_class                  |
| concept_complex                |
| concept_datatype               |
| concept_description            |
| concept_map_type               |
| concept_name                   |
| concept_name_tag               |
| concept_name_tag_map           |
| concept_numeric                |
| concept_proposal               |
| concept_proposal_tag_map       |
| concept_reference_map          |
| concept_reference_source       |
| concept_reference_term         |
| concept_reference_term_map     |
| concept_set                    |
| concept_set_derived            |
| concept_state_conversion       |
| concept_stop_word              |
| concept_word                   |
| drug                           |
| drug_ingredient                |
| drug_order                     |
| encounter                      |
| encounter_provider             |
| encounter_role                 |
| encounter_type                 |
| field                          |
| field_answer                   |
| field_type                     |
| form                           |
| form_field                     |
| form_resource                  |
| global_property                |
| hl7_in_archive                 |
| hl7_in_error                   |
| hl7_in_queue                   |
| hl7_source                     |
| liquibasechangelog             |
| liquibasechangeloglock         |
| location                       |
| location_attribute             |
| location_attribute_type        |
| location_tag                   |
| location_tag_map               |
| logic_rule_definition          |
| logic_rule_token               |
| logic_rule_token_tag           |
| logic_token_registration       |
| logic_token_registration_tag   |
| note                           |
| notification_alert             |
| notification_alert_recipient   |
| notification_template          |
| obs                            |
| order_type                     |
| orders                         |
| patient                        |
| patient_identifier             |
| patient_identifier_type        |
| patient_program                |
| patient_state                  |
| person                         |
| person_address                 |
| person_attribute               |
| person_attribute_type          |
| person_merge_log               |
| person_name                    |
| privilege                      |
| program                        |
| program_workflow               |
| program_workflow_state         |
| provider                       |
| provider_attribute             |
| provider_attribute_type        |
| relationship                   |
| relationship_type              |
| report_object                  |
| report_schema_xml              |
| role                           |
| role_privilege                 |
| role_role                      |
| scheduler_task_config          |
| scheduler_task_config_property |
| serialized_object              |
| test_order                     |
| user_property                  |
| user_role                      |
| users                          |
| visit                          |
| visit_attribute                |
| visit_attribute_type           |
| visit_type                     |
+--------------------------------+
102 rows in set (0.05 sec)

mysql>