Setting up MySQL server on local machine
As a developer, you know that a database is an important element in almost any application you are going to develop. If you are working on a software on you local machine, or even a cluster of machines each having its own role, a database server is always required.
There are varieties of databases to select from, such as RDBMS (Relational Database Management System) and NoSQL (literally, it means No SQL), depending on your requirement and the software design.
RDBMS examples are Microsoft SQL Server, Oracle, and MySQL.
NoSQL examples would be mongoDB, Amazon DynamoDB, and Apache Cassandra.
MySQL Database
MySQL is a Relational Database Management System (RDBMS) which, as per orcale.com’s “What is MySQL” definition, is:
MySQL is the world’s most popular open source database. According to DB-Engines, MySQL ranks as the second-most-popular database, behind Oracle Database. MySQL powers many of the most accessed applications, including Facebook, Twitter, Netflix, Uber, Airbnb, Shopify, and Booking.com.
MySQL adopts the standard SQL scripts plus some MySQL specific syntax. You can read more about MySQL if you are interested in knowing more in https://www.oracle.com/mysql/what-is-mysql/
