This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
2019-03-17 [2019/09/10 11:21] nmckillop |
2019-03-17 [2019/09/10 11:22] (current) nmckillop |
||
---|---|---|---|
Line 9: | Line 9: | ||
Here are the steps we took: | Here are the steps we took: | ||
- | ---- | + | See: [[Getting Started Part 2]] |
- | * Install mysql-server (and php-mysql, php etc in case we didn’t have them already): | ||
- | |||
- | 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: | ||
- | |||
- | wget https://github.com/vrana/adminer/releases/download/v4.7.3/adminer-4.7.3.php | ||
- | |||
- | * Then copied 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 | ||
- | |||
- | ---- | ||