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

posta 2 mesi fa69 visualizzazioni
2 Risposte
2
Risposta accettata

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
ESPERTO
con risposta 2 mesi fa
profile picture
ESPERTO
verificato 2 mesi fa
0

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

con risposta 2 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande