This shows you the differences between two versions of the page.
| 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 | ||
| ---- | ---- | ||