Unknown initial character set index '192'

[jmraz15]

This is the error when i try to log in:

javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory (Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.)

Anyone know a fix on this problem?
What is that unknown character set(index192)?
I think there's no problem with the connection...the problem is in that character set. anyone can help?

[jmraz15]

Ok. I fixed the problem:

I just comment out the

#collation_server = utf8_unicode_ci
#character_set_server = utf8

in the my.cnf file in /etc directory. i don't know how will it effect the mysql though.

hope this will help others who would have the same problem.