Upgrade mysql from 5.7 to Mysql 8.0 some issues

[castris]

After read and apply several docs about mysql issues on upgrade mysql form 5.7 to 8.0, I get some problems with phpMyAdmin and roundcube

1. check access of da_admin user with password in /usr/local/directadmin/conf/mysql.conf using mysql -uda_admin --ppassword_here (without problems)
2. Directadmin interface work fine
3. try rebuild cd /usr/local/directadmin/custombuild && ./build all d
4. In /usr/local/directadmin/conf/directadmin.conf the're mysql_detect_correct_methods=1 mysql_use_new_user_methods=1

Remove da_roundcube

mysql> DROP DATABASE da_roundcube;
Query OK, 15 rows affected (0.08 sec)


mysql> exit
Bye
root@server-xerintel01:/usr/local/directadmin/custombuild# ./build roundcube
Inserting data to mysql and creating database/user for roundcube...
Found MySQL version 8.0
Granting access: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,LOCK TABLES,INDEX,REFERENCES ON da_roundcube.* TO 'da_roundcube'@'localhost';
Setting password: ALTER USER 'da_roundcube'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yuCf7CImtO5';
Database created, da_roundcube password is yuCf7CImtO5
Editing roundcube configuration...
Roundcube 1.4.11 has been installed successfully.
WARNING: Changed defaults (These config options have new default values):
- 'skin'
- 'smtp_port'
- 'smtp_user'
- 'smtp_pass'
- 'jquery_ui_skin_map'
Executing database schema update.
ERROR: SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers
ERROR: Failed to connect to database

Both in Roundcube and in phpMyADmin I cannot log in due credentials error.

Any ideas?

 

[castris]

The solution is edit /etc/my.cnf and restart mysqld for apply a character set of server tu utf8 intestead utf8mb4

This solution is needs for work roundcube and phpmyadmin also.

```
character-set-server=utf8
```