Set-up Amazon LAMP

01.httpd.sh

# Connect to LAMP Server using a id_rsa
ssh -i ~/Projects/path-to/id_rsa username@servername

sudo bash               # Set the correct user rights for this session
cd /var/www/            # Change directory to the parent of Doc Root
chown -R username html  # Assign Doc Root to the user `username`
chgrp wheel html        # Set Apache Group to the `html` Folder
 
# Apache im Bedarfsfall neu starten
sudo service httpd restart

# Start MySQL Server
/sbin/service mysqld start  # Start MySQL Server
mysql -u root               # Login to Database Server

02.database.sql

/* User des Projekts erstellen */
CREATE USER 'myUser'@'localhost' IDENTIFIED BY 'myPassword';
 
/* Zugriff erteilen und Benutzereinstellungen neu laden */
GRANT ALL PRIVILEGES ON * . * TO 'myUser'@'localhost';
 
FLUSH PRIVILEGES;
 
/* Datenbank anlegen */
CREATE DATABASE tablename;
USE tablename;
 
/* Tabellen anlegen */
CREATE TABLE `foobar` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
/* Kontrolle */
DESCRIBE advent_profiles;