Install Dependencies

In this article, we will practice on a Windows machine.

Install NodeJS

  1. Go to this page to download Node.js v25.8.1 note
  2. For better understanding, you should follow the video below to install NodeJS on your personal computer.

Install MySQL Community

  1. Go to this page to download MySQL Community v8.0.45 note

  2. Similarly, watch this video to install MySQL:

Some notes when installing MySQL:

  • You should install both MySQL Client and MySQL Server for easier testing. Also, install MySQL Workbench and MySQL Shell, which is a database management system similar to Microsoft SQL Server Management Studio for Microsoft SQL Server. You may need them in some future projects.
  • In MySQL, there are two types of users: Root User and other users, each with different roles. Always remember the password for the Root User, and add a new account when installing MySQL Server. note

Results

Once NodeJS is installed, npm will also be included in the package. Check whether NodeJS and npm have been successfully installed using the following two commands:

node -v
npm -v

note

Using MySQL Shell

  1. Search for MySQL Shell in the Windows search bar, then select MySQL Shell.

note

  1. When opened, you will see the following interface:

note

  1. Type \sql to switch the Input Mode to MySQL.

2.1.4

  1. Then, connect to the MySQL Server by running: \connect root@localhost

2.1.5

If you didn’t create a user during the MySQL installation, you can connect to the MySQL Server using the Root User. In that case, the connection string will be root@localhost, and don’t forget to enter the Root User password you set during installation.

  1. Use the SHOW DATABASES; command to check the result again.

2.1.5

  1. Use \use fcajresbar; to switch to the fcajresbar database.

2.1.5