* [[Getting Started|Back to Getting Started overview]]
  * [[Setting up EC2|(previous) Getting Started Part 1: Setting up EC2]]

====== Getting Started Part 2: Installing Web/DB/PHP ======

  * Now we'll install the web server (Apache), the database (MySQL) and PHP:

  sudo apt update
  sudo apt install apache2 php php-mysql mysql-server

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

  sudo 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 (i.e. do this in putty, don't download it to your laptop):

  wget https://github.com/vrana/adminer/releases/download/v4.7.3/adminer-4.7.3.php

  * Then copy the file we downloaded to the web directory:

  sudo cp adminer-4.7.3.php /var/www/html/adminer.php

  * Now we could access the Adminer program by adding ''/adminer.php'' to your public Amazon EC ip address

  * [[Getting Started Part 3|(next) Getting Started Part 3: Hello World]]