Can't get MySQL database to change character set

I was getting an "Invalid collage blending" error in my database, so I figured I should go ahead and set my database and all tables to UTF-8.

I found a command on how to do this (), but I got the following error:

1 - Can't create/write to file './databasename/db.opt' (Errcode: 2)

      

        
        
        
      

    

Then I found this to help: MySQL error 1 (HY000) Failed to create Errcode 2 file , but the solution didn't work. I still get the same error.

I don't know what to do other than delete the database and restore it, but this seems like an edge-to-edge solution. I am also struggling to figure out how I can modify all tables in the database, again except for the dump and restore.

Does anyone have any suggestions on how I can fix this error? Drops the database just my variant? Is there some kind of permission that I am not aware of?