QGIS 2.18.x - How to create a view in MySQL database and work it in QGIS

A "view" is the result of a query built from a table stored in the MySQL database. In cause of that, a "view" is just a virtual table. There are several advantages to working with a "view". One advantage has to do with the fact that user can work only with a small part of the information stored in a table. Another advantage, it’s the saving of resources, being the “view” a virtual table, it does not consume hard disk space.
Now, you can ask: Can a user create "views" from spatial tables and see the geometries stored in it? The answer is yes!
Let's see, step by step, how to do it.