On Ubuntu systems running MySQL 5.7 (and later), the root user is using the auth_socket authentication method by default. Bluecherry won't be able to export and import database because of this, a workaround for this is to enable password authetication for the root user.


ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'very_strong_pasword';

FLUSH PRIVILEGES;