====== Guides: Web server: Part 2 ======
  * [[:guides/webserver|Back to Guides: Webserver]]
  * [[:guides/webserver/part1|Back to Guides: Webserver Part 1]]

====== Installing Web/DB/PHP ======

  * Now we'll install the web server (Apache), the database (MySQL) and PHP:
<code bash>
sudo apt update
sudo apt install apache2 php php-mysql mysql-server
</code>

  * Connect to the database as the root (admin) user:
<code bash>
sudo mysql -u root
</code>
  * 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:

<code sql>
create database coding;
CREATE USER coding_username IDENTIFIED BY 'cheese';
GRANT ALL privileges ON coding.* TO coding_username;
quit;
</code>

  * 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 on your server, don't download it to your laptop):

<code bash>
wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
</code>

  * Then copy the file we downloaded to the web directory:
<code bash>
sudo cp adminer-4.8.1.php /var/www/html/adminer.php
</code>

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

  * [[:Guides/Webserver/Part3|(next) Webserver Part 3: Hello World]]