Updating the old MySQL beta snap

Over a year ago we did some work on getting a MySQL snap up and running, but were blocked by certain missing features such as the ability to drop privileges. We’d now like to get this snap updated both to get an updated view of the status of snapcraft and to possibly find some new ways of looking at the issues.

Current snapcraft source is at https://github.com/mysql/mysql-snap/tree/8.0

The biggest issue I have is with paths; When running the snap it no longer uses $SNAP as the base path for libraries and other binaries, so the scripts fail to find mysql|mysqld, mysqld fails to find required library files like libaio.so.1, etc.

Is there a simple way to deal with this, or is the idea that one should either specify each path manually with the environment keyword, or reorganize all files in the same location?