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).
Here are the steps we took:
sudo apt install apache2 php php-mysql mysql-server
sudo mysql -u root
create database coding; grant all on coding.* to coding_username@localhost identified by ‘cheese’; quit
sudo cp adminer-4.7.1-en.php /var/www/html
/adminer-4.7.1-en.phpto your public Amazon EC ip address
That’s about as far as we got, but it’s a good base for future projects.
This was the game link I mentioned that helps you learn how to the use the command line/bash: Over The Wire War Games