simple-phonebook-web-application with MySQL versión 8

0

Hello, i am trying to execute this app from aws samples : simple-phonebook-web-application But when i try Connect to bd It returns this error: Unable to Establish Connection:Server sent charset unknown to the client. Please, report to the developers. I think that IS due to this IS not compatible with version 8 of MySQL . How can i run this app with mysql8? Or is there other similar sample app compatible with mysql8? Thanks very much in advance!! Alberto

asked a month ago44 views
2 Answers
2
Accepted Answer

Hello.

Starting with MySQL8, the default character code seems to be utf8mb4, so I think this is probably the problem.
Therefore, try changing the character code to utf8 in the parameter group set in the RDS instance, or change the character code of the table created within RDS to utf8.
https://stackoverflow.com/questions/43437490/pdo-construct-server-sent-charset-255-unknown-to-the-client-please-rep

I think the answers below will be helpful.
https://stackoverflow.com/a/58959536

For setting MySQL's character code, please check the parameters introduced in the blog below.
It is explained in detail in "Parameters related to character sets".
https://aws.amazon.com/jp/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-3-parameters-related-to-security-operational-manageability-and-connectivity-timeout/

profile picture
EXPERT
answered a month ago
profile picture
EXPERT
reviewed a month ago
0

thanks! i solved it with: ( I think the answers below will be helpful. https://stackoverflow.com/a/58959536 )

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions