I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. I wanted to change the default format yyyy-mm-dd to dd-mm-yyyy. Based on my research I can do this using "Default transformations for DateFormat" setting. However when I set the new "%d-%m-%Y" format in "Default transformations for DateFormat", it does not change the format of my existing date data or new inserted date. It remains with the yyyy-mm-dd. Is this a bug?