MySQL

MySQL is a widely used open-source relational database management system that operates using the client-server model over the Application layer usually in port 3306. It is primarily used for storing, managing, and retrieving structured data efficiently and implements a client-server model.

Its main features are:

  • Can use SSL/TLS for secure encrypted connections

  • Manages structured data with SQL queries

  • Supports transactions, indexing, and stored procedures

  • Allows remote and local database access for applications

Query syntax is the standard SQL syntax for simplicity.

Query Syntax

  • We use the command line utility to connect to a database and once inside we use standard SQL queries

mysql -u $user #Set user
mysql -h $host #Set host
mysql -u $user -h $host -p #Prompt for password
mysql -u $user -h $host -p #Prompt for password
mysql -u $user -h $host --skip-ssl #Don't use SSL for the connection
PreviousSQLNextMSSQL

Last updated