Features of MySQL

Identify Storage Engines

Research and list at least three MySQL storage engines and describe their primary use cases.

Expected output: A list describing each engine and when to use it.

Hint: Focus on InnoDB, MyISAM, and Memory engines.

Create a Secure User

Write SQL commands to create a MySQL user with limited privileges for a specific database.

Expected output: SQL statements that create a user and assign minimal necessary privileges.

Hint: Use GRANT and REVOKE statements.

The main storage engines are InnoDB and MyISAM. InnoDB supports transactions, foreign keys, and row-level locking, making it suitable for transactional applications. MyISAM is faster for read-heavy workloads but lacks transaction support and uses table-level locking.

MySQL ensures data security through user authentication, granular access control, SSL/TLS encrypted connections, data encryption at rest and in transit, and audit logging.

Yes, MySQL is cross-platform and runs on Windows, Linux, macOS, and other operating systems, providing flexibility for deployment.