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 | ||
---- | ---- |