Upgrade mysql from 5.7 to Mysql 8.0 some issues

castris

Verified User
Joined
Apr 16, 2021
Messages
16
Location
Arcenillas
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

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


mysql> exit
Bye
[email protected]:/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?
 

Attachments

  • Castris_20210528_104941.jpg
    Castris_20210528_104941.jpg
    40.1 KB · Views: 21
  • Castris_20210528_104956.jpg
    Castris_20210528_104956.jpg
    43.3 KB · Views: 35

castris

Verified User
Joined
Apr 16, 2021
Messages
16
Location
Arcenillas
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
```
 
Top