@passegua for info it has nothing to do with the WordPress admin panel.
It depends on the hosting company.
Generally, you can find this setting inside the “admin center” or “manager” of the hosting company (where you can manage DNS, php versions and… databases)
I hope it will help.
@passegua Hello. I was struggling with this error for a few days also.
@rostymatviyiv is right.
I have changed the rights of the database user : you have to be sure that the user can “CREATE” and not only “READ” “WRITE” etc.
Then I deactivated the plugin which caused problems.
Then I ran the plugin Fix Action Scheduler Action IDs :
https://gist.github.com/rrennick/165225412aca1a4fc04f05898cb97101
It created the tables.
Then I Activiated AIOSEO again! –> OK!
Thank you @rostymatviyiv !