Acl command prompt migration (bin/cake migrations migrate -p Acl) gives me an error in cakephp 4.4

I am trying to migrate the acl tables in windows 10 command prompt (I have wampserver installed in my notebook) but gives me general error 1709 index column size too large, how can I solve this issue?
I attach screenshot with the error:

Make sure you are using a collation based on something like utf8mb4. The important part is the mb4.

See e.g. indexing - How to fix MySql: index column size too large (Laravel migrate) - Stack Overflow which is the same issue just with laravel.

So its not cakephp/acl’s issue, its what kind of database (or more specifically the settings for your database) you are using.