If you get an error like this:
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Unknown initial character set index ‘192’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.
Then in the database connection settings, do as highlighted in the screenshot below.