Thunder board not recognised (EDIT: + MySQL stuff)

After doing more reading (I'm a teacher dammit... I shouldn't be studying!), I've figured it out and have moved quite far on. 

The documentation really could do with some work, so I'll be replying with the post later (after the weekend and typhoon have passed) with my full step-by-step list!

It's definitely hard work, but it'll be worth it in the end

Installing MariaDB


sudo apt-get install mariadb mariadb-server


Once installed, check whether is has been enabled:
systemctl is-active mariadb  
systemctl is-enabled mariadb
The first command should say “active”, the second should give a result of “enabled”.

If it doesn’t, then we will need to start it:
systemctl enable mariadb
systemctl start mariadb
Now the basic install doesn’t complete the full set up so our next step is to configure MariaDB with a password etc…

sudo mysql_secure_installation
This will ask you to
a) set a root password
b) remove anonymous users
c) allow remote root login
d) remove the test database
e) reload privilege tables immediately (to allow a-d to take effect)

sudo apt-get install python-mysqldb
This step installs the python to mysql bindings

(Taken from www.rootusers.com/how-to-install-and-configure-mariadb/ and SkyWeather github instructions)

Adding the SkyWeather database

Now that mySQL is installed, let’s set up the database:

mysql -u root -p

This enters into MySQL. Next step is to create our SkyWeather database:

CREATE DATABASE database_name;

(Change database_name to your choice… e.g sky_weather... also, note the semi-colon at the end!)

quit (or CTRL-D)

Next, move to the SkyWeather installation directory:

cd SDL_Pi_SkyWeather
cd SkyWeatherSQL

This next command imports the template database into the database we created earlier.

sudo mysql -u root -p database_name <  WeatherPiStructure.sql

(Taken from www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb and SkyWeather instructions on github)

Hope this helps some people!
I'll add more later (and possibly make a new post with a more complete version) once I've finished the waterproofing of the box... I'm out of superglue and silicon caulking