How to change MySQL default storage engine on Rocky Linux 8.6

Storage engines are software modules used by database management systems to create, read, and update data in databases. In MySQL, there are two types of storage engines: transactional and non-transactional. The default storage engine for MySQL prior to version 5.5 was MyISAM.

For more explanation on this video: https://www.linuxhelp.com/how-to-change-mysql-default-storage-engine-on-rocky-linux-8-6