DEV Community

Raj Madisetti
Raj Madisetti

Posted on

1 1

MySQL: Client and Server Model Databases


Hello fellow Javascript coders,

In this article, we will be discussing MySQL which is a very popular database management system based on a client-server model. To get a perspective on how useful and widespread this way of structuring application is, we can take a look at the many popular webs apps that you and I use everyday including YouTube, PayPal, Google, Twitter, and Facebook. All of those platforms use MySQL to structure the different and countless amounts of data that they send and receive to and from every user on their websites.

First, let's explore what a MySQL database is. MySQL is a database management system that can run on any platform (Linux, MacOS, and Windows) and is based on SQL (Structured Query Language). MySQL runs on the client-server model which means that the MySQL server can send client interfaces to multiple users simultaneously. These interactions with the server allow the client to send individual SQL statements in order to garner a response to their user interface. These SQL statements include ADD, DROP, INSERT, and UPDATE and can be used to adequately navigate through the database and perform a desired action on each entry.

If any random client could establish a connection with a MySQL server, there could be a potential security breach if the client had malicious intent on sabotaging the server. Luckily, MySQL has security features built in to prevent the threat from happening. MySQL uses a host-based verification system that uses access privilege and passwords to keep out anonymous dangers to the server.

Top comments (0)

Jetbrains image

Build Secure, Ship Fast

Discover best practices to secure CI/CD without slowing down your pipeline.

Read more

👋 Kindness is contagious

Dive into this thoughtful article, cherished within the supportive DEV Community. Coders of every background are encouraged to share and grow our collective expertise.

A genuine "thank you" can brighten someone’s day—drop your appreciation in the comments below!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found value here? A quick thank you to the author makes a big difference.

Okay