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] [2019] 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?

Answers


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.


Need Your Help

In python 2.7, how can I compare lines with the number of items in a list?

python loops if-statement python-2.7

I am trying to print line[4] if there are 4 items, or line [4] and [5] if there are more than 4 items.

Regex Named Groups in Java

java regex

It is my understanding that the java.regex package does not have support for named groups (http://www.regular-expressions.info/named.html) so can anyone point me towards a third-party library that ...