PiPlanter | Basic package setup and bringing everything together

I’m in a hotel trying to occupy myself with something interesting so I’ve decided to work on this. I had to re-image the SD card I’ve been developing this project on, but I saved to code so there’s no problem there. Now I need to re-install all the basic packages.

First I need to get the components of a LAMP server with the following commands:

Shell

1

2

3

4

5

sudo apt-getinstall apache2

sudo apt-getinstall mysql-server

sudo apt-getinstall php5

sudo apt-getinstall php5-server

sudo apt-getinstall php5-mysql

Once you get the mysql server setup, you’ll need to create a database and tables in mysql.

To create the database you’ll be using run the following command:

Shell

1

CREATE DATABASE piplanter;

And then grant the proper privileges to use later with the command:

Shell

1

2

mysql>mysql>GRANT ALL PRIVILEGES ON piplanter.*TO'user'@'localhost'IDENTIFIED BY'pass';

Hey! This post was written a long time ago, but I'm leaving it up on the off-chance it may help someone, but proceed with caution. It may not be a good idea to blindly integrate this code or work into your project, but instead use it as a starting point.