Question: how to change default date format in phpmyadmin?
Answer: Go to the Structure page of the relevant table.
Click on the Change hyperlink in the Actions column of the relavent date/datetime/timestamp column.
Chose Text/Plain: Dateformat from the Browser Transformation dropdown.
Insert 0,'%d-%b-%Y','local' into the transformation options column.