dpkg: error processing package mysql-common

dpkg: error processing package mysql-common (--configure):
 installed mysql-common package post-installation script subprocess returned error exit status 2
dpkg: dependency problems prevent configuration of mysql-community-client:
 mysql-community-client depends on mysql-common (>= 8.0.23-1debian10); however:
  Package mysql-common is not configured yet.
  Version of mysql-common on system, provided by mysql-common:amd64, is <none>.

dpkg: error processing package mysql-community-client (--configure):
 dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.28-10) ...
Errors were encountered while processing:
 mysql-common
 mysql-community-client
E: Sub-process /usr/bin/dpkg returned an error code (1)

Solution:

sudo apt-get clean
sudo apt-get update
sudo dpkg --purge mysql-community-client
sudo dpkg --purge mysql-community-server

sudo apt-get purge mysql\* mariadb\* libmysql\* libmariadb\*

sudo apt install mysql-common --reinstall
sudo dpkg --purge mysql-common

apt list --installed | grep mysql