Knowledgebase : Database

When installing sql server express 2019, there are a few tasks to get it available from the outside world

1) By default TCP/IP isn't enabled, also it uses a dynamic port, and finally even when you set the port to 1433 (Standard Sql Server Port) you still have to use the ,1433 notation to force SSMS to use that port. Details at https://dba.stackexchange.com/questions/62165/i-cant-connect-to-my-servers-sql-database-via-an-ip-address

2) Allow Sql through the firewall - the exe is in "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" for SqlServer 2019

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

Copyright © RAPID BI Pty Ltd 2020