CREATE TYPE on MySQL

You can use JSON data type now. MySQL supports the native JSON data type since version 5.7. 8.

You cannot. MySQL doesn't have user-defined types. (At least, not in current versions.)