Posts

Showing posts with the label MYSQL

Creating Login and Registration Application Using NodeJS and MySQL!

Image
Creating Login and Registration Application Using NodeJS and MySQL Creating Login and Registration Application Using NodeJS and MySQL rather than using any Programming Languages to interact with back-end databases, we are going to use ExpressJS which gives us very good flexibility over Node.js.  To start with this application required following 1. NodeJS 2. ExpressJS 3. MySQL Install NodeJS $  npm install node Install ExpressJS $ npm install express --save Install MySQL $ npm install mysql--save Create a database by simply typing a command mysql> create database test; Check your database exist in your databases list simply type a command mysql> show databases;  Choose the database to work around with select database by typing command mysql> use test; Create a users table in that database. To create a users table type command CREATE TABLE `users`(`id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` ...

How to set MYSQL root password ?

The command is MySQL 5.7.6 and later: ALTER USER 'root' @ 'localhost' IDENTIFIED BY 'MyNewPass' ; MySQL 5.7.5 and earlier: SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ( 'MyNewPass' ) ;

DBMS vs. RDBMS

DBMS vs RDBMS: Key Differences and Use Cases Database systems are essential for managing and organizing data efficiently. Two common types of database management systems are DBMS (Database Management System) and RDBMS (Relational Database Management System) . While they may seem similar, there are important differences in how they store, manage, and enforce relationships among data. Understanding DBMS A DBMS is software that allows users to store, retrieve, and manage data in a database. It provides an interface between end-users, applications, and the database itself. Key Features of DBMS: Data Model Flexibility : Supports hierarchical, network, object-oriented, or other data models. No Structured Data Requirement : Can store data in flat files, unstructured, or semi-structured formats. Minimal Data Integrity Constraints : Does not enforce strict integrity rules by default. Performance and Scalability : Optimized for quick data retrieval; may compromise on data con...