Meme Database

Simple meme database web page, built with MySQL and Node.js.

Prerequisites

• MySQL and Workbench
• Node.js
• NPM (Installed automatically with Node.js)

Checkout this project

$ git clone https://github.com/rwait8831/meme-store.git/

Install Node.js and NPM

sudo snap install node --classic --channel=12

Setup your database

Open MySQL Workbench from your start menu, or run the MySQL CLI with:

$ sudo mysql

Create a new database schema:

create database yelp; 
use yelp;

Grant your existing sqluser permissions on that schema:

ALTER USER 'sqluser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'sqluserpw';
GRANT USAGE ON *.* TO sqluser@localhost;
GRANT ALL PRIVILEGES ON yelp.* TO sqluser@localhost;

Project dependencies

Open this project in Visual Studio Code. Open a new Terminal from the menu, or use Ctrl+Shift+`
Install dependencies:

$ sh install.sh

Run the web server with

$ sh start.sh

Open a web browser, and navigate to localhost:3000.