docker

wikum@msi:~$ docker run -p 3306:3306 --name openmrs -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7.43 --default-authentication-plugin=mysql_native_password -h 127.0.0.1
26af5c4a04d9a4ef64b11fc486aa553c27f00d0abff964af36317bcc964a53b2
wikum@msi:~$ docker ps
CONTAINER ID   IMAGE          COMMAND                  CREATED          STATUS          PORTS                                                  NAMES
26af5c4a04d9   mysql:5.7.43   "docker-entrypoint.s…"   32 seconds ago   Up 31 seconds   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   openmrs
wikum@msi:~$ docker exec -it 26af5c4a04d9 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 3
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.00 sec)