Nodejs MySQL Aplicacion Completa (LinksApp)

Nodejs y MySQL CRUD

Este es un proyecto de Nodejs y MySQL que permite a usuarios crearse una cuenta y autenticarse. Ademas de poder ejecutarse usando Docker

Paquetes principales

• mysql2, https://www.npmjs.com/package/mysql2
• passport, https://www.passportjs.org/
• cookie-parser, https://www.npmjs.com/package/cookie-parser
• express-handlebars, https://www.npmjs.com/package/express-handlebars
• express-validator, https://express-validator.github.io/docs/
• nodemon, https://www.npmjs.com/package/nodemon
• morgan, https://www.npmjs.com/package/morgan
• connect-flash, https://www.npmjs.com/package/connect-flash
• express-mysql-session, https://www.npmjs.com/package/express-mysql-session
• Bootstrap5, https://getbootstrap.com/

Tecnologias principales

• Nodejs
• Docker
• MySQL

Docker mysql

docker run --name mymysql -e MYSQL_ROOT_PASSWORD=mypassword -p 3306:3306 -d mysql --default-authentication-plugin=mysql_native_password

• https://hub.docker.com/_/mysql

Deploy

To deploy I wil use a free Mysql Hosting called Clever cloud.

1. Create an Account, and confirm the activation using your email. This will give you 20$ free to use it.
2. Go the Personal Space > create > create addon > MySQL, put a name and choose a zone.
3. paste the credentials in your application

Más Recursos

• Passport
  • Docs: https://github.com/passport/www.passportjs.org/tree/master/docs
• mysql authentication, https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server