show columns from prefix_user;
http://meta.wikimedia.org/wiki/MediaWiki_FAQ#Basic_User_Account_Management.3F
As a sysop, how do I see basic information about users like username, realname, email? How do I find the ip of a user for previous edits? What is the best way to roll back a users edits globally?
The following should help (using mysql):
show columns from prefix_user;
select user_name, user_real_name, user_email from prefix_user;
documented on: 22 January 2007, Jonathan1
wiki_db_name= wiki_db_user= wiki_db_pass= wiki_tb_prefix=