reminder

Retrieve cleartext from binary encoded Mediawiki database tables

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;

Subscribe to RSS - reminder