Missing UTF-8 charset in MAMP MySql
I am trying to run a MySql database with MAMP, but when I try to access the database, this error appears:
SQLSTATE[HY000]  Can't initialize character set UTF-8 (path: /Applications/MAMP/Library/share/charsets/)
I ran "show variables" and found that the charset is set to UTF-8. I also looked in the path mentioned in the error and found that there was no file that said anything about UTF-8, so it appears that this charset is missing. Huh??? If it's looking for this charset, it must usually be present. So why is the charset missing? How can I get it there?
I had a similar problem. In my case I mistyped UTF-8 for establishing the connection. Try to connect with the charset "utf8" instead of "UTF-8".
Apart from that I also have no UTF-8 charset file in that folder so I guess it's not the real problem.