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.