CRUD MySQL Project from scratch(using Node.js and React). Create, Read, Update and Delete data using a MySQL database.
//mysql workbench community download
connect to DB server:
create new Schema, with R click mоuse:
creating a new table:
//if there is a auth problem in --> app.get("/books",....)
// Execute the following query in MYSQL Workbench:
//ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root(password)'; <-----
//Where root as your user localhost as your URL and password as your password
//Then run this query to refresh privileges:
//flush privileges; <----
//Try connecting using node after you do so.
//If that doesn't work, try it without @'localhost' part.
//npm init -y
//npm i express
//npm i mysql
//npm i nodemon
//npm i cors
Postman test :
//middleware -- allow us to send JSON (from POSTMAN for example) data to EXPRESS server: ---> app.use(express.json());
//npx create-react-app .
//npm i react-router-dom
//npm i axios
