Hi all, here are some notes from the meetup today:

We went through making sure everybody had an Amazon EC2 instance they could access, then we installed mysql, created a database and user, then installed an admin tool, Adminer.

For anyone who hasn't got their instance setup, I have a video here that takes you through it (only the first 20 minutes or so are relevant, and remember to change your server location to Europe/London): https://peertube.armchairscientist.co.uk/videos/watch/e5ff67cd-2b73-4a60-9fdd-abc0c474211b

Here are the steps we took:

Install mysql-server (and php-mysql, php etc in case we didn’t have them already):

    sudo apt install apache2 php php-mysql mysql-server

Connect to the database as the root (admin) user:

    mysql -u root

Then, inside the mysql client, we created the database and created a user called ‘coding_username’, with the password ‘cheese’ and gave it access to the newly created ‘coding’ database:

    create database coding;

    grant all on coding.* to coding_username@localhost identified by ‘cheese’;

    quit

Then we downloaded the Adminer software (https://www.adminer.org/) using the command line downloader on the Amazon instance:

    wget https://github.com/vrana/adminer/releases/download/v4.7.1/adminer-4.7.1-en.php

Then copied the file we downloaded to the web directory:

    sudo cp adminer-4.7.1-en.php /var/www/html

Now we could access the Adminer program at http://your public amazon EC ip/adminer-4.7.1-en.php

That’s about as far as we got, but it’s a good base for future projects.

I’ll get a wiki set up shortly so we can collate our notes (I’ll post the address to the forum). Remember, you can always find a couple of us on the IRC server if you have any questions (more details at https://irc.armchairscientist.co.uk/).