Update (DML command)

Delete (DML command)

DROP (DDL command)


When you install MySQL v9 database software:
- 78 System tables are automatically created. The system tables store complete information about the database. (For example: which users are there, what info has stored with user)
- 4 users are automatically created.
- A few (6) system databases are automatically created.
Users:
- root
- root→ has Database Administrator (DBA) privileges.
- create database, drop database, alter database, configure database, create users, assign privileges, take backups, recover from the backups, performance monitoring, performance tunning, performance planning, performance management etc.
- mysql.sys
- most important user (more important than root user)
- It is owner of MySQL Server installation and owner of System tables.
- Job: Startup database, shutdown database, perform Recovery.