User Tools

Site Tools


2018-03-17

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
2018-03-17 [2019/03/18 13:31]
nmckillop created
2018-03-17 [2019/03/24 14:17] (current)
nmckillop
Line 14: Line 14:
   * Install mysql-server (and php-mysql, php etc in case we didn’t have them already):   * 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''​+  ​sudo apt install apache2 php php-mysql mysql-server
  
   * Connect to the database as the root (admin) user:   * Connect to the database as the root (admin) user:
  
-'' ​   ​mysql -u root''​+  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:   * 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; +  ​create database coding; 
- +  grant all on coding.* to coding_username@localhost identified by ‘cheese’;​ 
- +  quit
-    ​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:   * 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''​+  ​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:   * Then copied the file we downloaded to the web directory:
  
-'' ​   ​sudo cp adminer-4.7.1-en.php /​var/​www/​html''​ +  ​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**+
  
 +  * Now we could access the Adminer program by adding ''/​adminer-4.7.1-en.php''​ to your public Amazon EC ip address
  
 ---- ----
2018-03-17.1552915914.txt.gz · Last modified: 2019/03/18 13:31 by nmckillop