MySQL
Password Hashing in MySQL 8.0: Authentication Plugins
In this article, we will explore the various password hashing mechanisms provided by MySQL 8 and how they can be used to secure user passwords.
MySQL Security: Best practices for Protecting Sensitive Data.
This article will give you the best practices for securing a MySQL installation and protecting sensitive data in your database.
Best practices for optimizing MySQL database performance.
In this article, we will discuss some best practices for optimizing MySQL database performance, and we'll talk about some top recommendations for improving MySQL database speed.
Automating Your MySQL Database with Triggers
This article presents an overview of triggers in MySQL and shows how to use them to automate tasks and simplify your MySQL database management.
How to use ON DELETE CASCADE in MySQL
In this post, we'll look at how MySQL's ON DELETE CASCADE feature works and how you can manage your database better.
MySQL + Event Scheduler: How to delete data from MYSQL table using Event Scheduler
This article aims to show you how to use MySQL Event Scheduler to schedule a DELETE query to remove data automatically from a MySQL table at a specific time and date or at regular intervals.
Using MySQL Event Scheduler: A Complete Guide
This article will show you how to create and use MySQL Event Scheduler to automatize your database management.
How to add Custom Error Handler Middleware to your Node.js/Express API
This post will discuss Error Handling and show you how to write and set up your own custom Error handler middleware function in Node.js/Express.js API.
Node.js + MySQL : Add Forgot/Reset Password to Login-Authentication System.
This tutorial will show you how to add and implement a forgot and reset password feature to your MySQL + node.js API by using the Nodemailer module to send an email link to the user account and allow him to reset his password when he forgets it securely.
Complete JWT Authentication and Authorization System for MySQL/Node.js API
This article will implement a complete authentication and authorization system with JWT to add a security layer to access protected routes within our MySQL/Node.js API.
How to implement Many-To-Many association in MySQL/Node.js API using async/await
This article provided a step-by-step tutorial showing how to easily implement a Many-To-Many association in MySQL/Node.js API using async/await calls.
How to implement One-To-One association in MySQL/Node.js API using async/await
This article will show you how to implement a One-To-One association in a MySQL database using async/await requests in a Node.js API.
How to implement One-To-Many association in MySQL/Node.js API
This article provided a step-by-step tutorial showing how to efficiently represent and implement a One-To-Many association in MySQL/Node.js API using async/await calls.
ONE-TO-ONE Association in MYSQL Database using Sequelize async/await with Node.js
This article will show you how to represent and implement a One-To-One association in a MySQL database using Sequelize async/await to interact with the database in a Node.js API.
MANY-TO-MANY Association in MYSQL Database using Sequelize async/await with Node.js
This tutorial provides a profound explanation of the many-to-many association and how to define and implement it using Sequelize async/await to interact with MySQL database in a Node.js API.
ONE-TO-MANY Association in MYSQL Database using Sequelize async/await with Node.js
This tutorial provides a profound explanation of the one-to-many association and how to define and implement it using Sequelize async/await to interact with MySQL database in a Node.js API.
How to add Routes to insert data into MySQL database-related tables in Node.js API?
This article will show you how to add routes to your Node.js/MySQL API to insert data into your database-related tables using Sequelize ORM.
How to use Sequelize async/await to interact with MySQL database in Node.js
This article will show you how to use Sequelize async/await to interact with MySQL Database in Node.js by building a Node.js Restful CRUD API using Express, Sequelize, and MySQL server.
Example How to use initialize() Function in Node.js/Express API
This article intends to show how you can use the initialize() function in a node.js API to create and connect a MySQL database and initialize the Sequelize models inside this function.
How to Build a Complete API for User Login and Authentication using MySQL and Node.js
This tutorial will teach you how to build a complete Node.js Login, Registration, and user management RESTful API using MySQL. For that, we will use node.js to develop our server and MySQL to store users and handle sessions.
How to store Session in MySQL Database using express-mysql-session
In this article, we will look at sessions and give you a nice and simple way of how to store them in MySQL database using express-mysql-session.
How to add MySQL to the Path in mac OS
This tutorial is a step-by-step guide on how to add MySQL to the path in your Mac OS system for local development.
How to interact with MySQL database using async/await promises in node.js
The combination async/await syntax promises makes writing MySQL queries in node.js easier with a better maintainability. This article intent is to show you how to use this combination to interact with MySQL database in node.js in a practical way.
Complete Guide to Build a RESTful API with Node.js and Express
This tutorial is walk through on how to build a complete RESTful API with node.js and Express and connect it to a MySQL database .
How to install MySQL Workbench on mac OS
In case you want to use a visual tool rather than just using Terminal to interact with your MySQL databases in a more structured way, MySQL Workbench is one of the best alternatives.
Install MySQL Server and MySQL Workbench on Windows
MySQL is the most popular DataBase Management Software. This tutorial shows how to download, install and setup MySQL on your Windows system .
How to create MySQL database with node.js
The following examples will show you exactly how to create a MySQL database with nodejs using the two types of connection: Single Connection and Connection Pooling.
How to connect node.js API to MySQL database
This tutorial is walk through on how to create a node.js API and connect it to a MySQL database using a : pool connection.
MySQL queries examples in node.js
In the Following, examples of INSERT, SELECT, UPDATE and DELETE queries necessary to operate all CRUD operations: Create, Read, Update and Delete. We will write our queries to get data or make changes to a table named “Employee”.