Using JS to create a modal menu using Sisense DOM service.

// making the prism dom injector look more friendly.
const $dom = prism.$injector.get('ux-controls.services.$dom')

// example of how information can be injected into the modal.
const info = 'hello world'

// creating HTML to be displayed by the modal
const popupHtml = `<div> ${info} </div>`

// setting up settings object for modal injector
const settings = {
  template: popupHtml,
  scope: 'fake',
  css: 'resize-modal',
  id: 'myModal'
} // Hack for $dom service

// create the modal using settings
$dom.modal(settings)

Running PHPMyAdmin locally to connect to a remote MySQL instance is made fast and easy with Docker.

Download Docker. This can be installed on Windows.

Open a cmd prompt and enter the following

docker pull phpmyadmin

This will install the PHPMyAdmin docker image

In the command prompt enter the following, changing IP with the IP of the MySQL server (this will work for MySQL hosted on AWS amongst others).

docker run --name myadmin -d -e PMA_HOST=IP -p 8080:80 phpmyadmin

Now access PHPMyAdmin in a web browser at http://localhost:8080/

Full documentation on docker commands for PHPMyAdmin is at: https://hub.docker.com/_/phpmyadmin