/full-stack-mysql2-app

A simple full-stack-mysql task app

Primary LanguageJavaScriptMIT LicenseMIT

Full-stack-MySQL-Task-App

A simple full-stack-mysql task app

Getting Started

You must have local MySQL installed first to run this very simple full-stack-mysql task based app.

Prerequisites

What things you need to install the application and how to install them

brew install mysql
mysql -u root
mysql -u root -p (if you are using password)

sudo npm install -g nodemon

Installing

Go to backend folder and install dependencies

cd backend
npm i

And move back to frontend folder

cd ..
cd frontend
npm i

Now go to the root of the folder and run

cd ..
npm i
npm start

MySQL Database connection

If you get "Unknown database" error message, this means you have to first create a database in your local MySQL shell/terminal

show databases;
create database taskdbreact23s;
show databases; (make sure you have this db)

Linting

To check for linting issues, you can go to frontend folder and run

npm run lint

Local Deployment

The application can be accessed locally from following address

http://localhost:5173/

Built With

  • React - The library for web and native user interfaces
  • MySQL - The world's most popular database
  • Express - Fast, unopinionated, minimalist web framework for Node.js
  • Sequelize - Node.js ORM for MySQL and other relational databases
  • Vite - Dev environment for front-end

Use as reference material

Please use as a reference material

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Read more