ERROR 1 (HY000): Unable to create / write to file './scraping/db.opt' (Errcode: 2)

Question

I work through the "Web Scraper with Python", and I work with MySQL in many ways. It is not possible to find anything particularly useful with this error message on Google - can any of you help me decode it? (and hopefully find out how to fix this ?!) I get an error message after entering the command:

ALTER DATABASE scraping CHARACTER set = utf8mb4 COLLATE = utf8mb4_unicode_ci;

output:

ERROR 1 (HY000): Can't create/write to file './scraping/db.opt' (Errcode: 2)
mysql> 

Answer 1

You must ensure that your database is called "scraping", I have ever made this mistake.