MySQL - ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

MySQL - ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

При удалении базы mymail получаем ошибку вида:

MariaDB [(none)]> drop database mymail;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

Решение этой проблемы:

MariaDB [(none)]> SET FOREIGN_KEY_CHECKS=0; drop database mymail; SET FOREIGN_KEY_CHECKS=1;