Submitted by dystopic on Mon, 04/09/2012 - 15:31
For me (who is not that familiar with databases and SQL) it was a little effort to find the right SQL statement to retrieve the cleartext from a binary encoded mysql table from a mediawiki (1.18.1) installation. The following little SQL statement did the trick, it gives the user names of all users in cleartext:
SELECT CONVERT `user_name` USING UTF8 FROM `user` WHERE 1;