wikum@msi:~$ docker run -p 3306:3306 --name openmrs -e MYSQL_ROOT_PASSWORD=root -e TZ=PDT -d mysql:5.7.43 --default-authentication-plugin=mysql_native_password -h 127.0.0.1
a4daef8ab5f15ac9f53735432cb0c01a9b35d2b7ebaf624e4f495ba883368100
wikum@msi:~$ docker ps
CONTAINER ID   IMAGE          COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
a4daef8ab5f1   mysql:5.7.43   "docker-entrypoint.s…"   7 seconds ago   Up 6 seconds   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   openmrs
wikum@msi:~$ docker exec -it a4daef8ab5f1 bash
bash-4.2# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.43 MySQL Community Server (GPL)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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> CREATE DATABASE openmrs;
Query OK, 1 row affected (0.01 sec)

mysql> USE openmrs;
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_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.00 sec)