Articles, notes and random thoughts on Software Development and Technology
Running and exposing default MySQL port:
docker run -e MYSQL_ROOT_PASSWORD=mypassword -p 3306:3306 -d mysql
mysql -u root -p
Running with a different exposed port on the host:
docker run -e MYSQL_ROOT_PASSWORD=mypassword -p 3307:3306 -d mysql
Connecting to server on different port : -P option, but also requires -h for host, otherwise seems to connect to whatever is running on 3306 by default:
mysql -h 127.0.0.1 -P 3307 -u root -p
Every time I fly in the UK in FS 2020 I forget which areas have photogrammetry, so here’s a quick list for future reference:
World Update XVII UK and Ireland (released 23 July 2024 added (from release notes here: https://www.flightsimulator.com/world-update-xvii-united-kingdom-ireland/) 16 TIN cities (triangulated irregular network) with surface modelling (higher resolution elevation data):
England:
Ireland:
Scotland:
Wales
5 handcrafted airports:
World Update III UK (from release notes here: https://forums.flightsimulator.com/t/release-release-notes-1-13-16-0-world-update-iii-united-kingdom-now-available/365854/1 and here: https://www.polygon.com/2021/2/16/22285851/microsoft-flight-simulator-world-update-3-united-kingdom-england-ireland-scotland-wales)
Added:
Handcrafted airports:
Summarized list from my previous post here: https://www.kevinhooke.com/2021/05/16/microsoft-flight-simulator-uk-cities-with-photogrammetry/
Original FS 2020 release cities:
mysql searches for your local my.cnf in a number of default places, so finding which is actually in use can be an issue.
To find which search paths are currently being used by your current mysql install (from here), use:
mysql --help | grep my.cnf
And it will show a list of paths like this:
> mysql --help | grep my.cnf
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /opt/homebrew/etc/my.cnf ~/.my.cnf
Note that if you installed mysql via homebrew (on MacOS), this will also show the homebrew path where my.cnf is located.
To ssh into AWS ec2 instances the default user id is usually ‘ec2-user’ (see my ec2 ssh checklist here).
Lightsail vps instances appear to use different default userids, depending on the OS. For example, for an Ubuntu Lightsail instance the default ssh userid is ‘ubuntu’:
ssh -i path-to-your-ssh-pen-file ubuntu@your-instance-ip