<rdf:RDF
    xmlns:rdf='http://www.w3.org/1999/02/22-rdf-syntax-ns#'
    xmlns:s='http://snipsnap.org/rdf/snip-schema#'
    xml:base='http://bliki.rimuhosting.com/rdf'>
    <s:Snip rdf:about='http://bliki.rimuhosting.com/rdf#start/mediawiki+password+reset'
         s:cUser='alex'
         s:oUser=''
         s:mUser='alex'>
        <s:name>start/mediawiki password reset</s:name>
        <s:content>Here&apos;s the SQL to reset the mediawiki password of a user:&#xD;&#xA;&#xD;&#xA;{code}use mediawikidb;&#xD;&#xA;update user set user_password=md5(concat(user_id,&apos;-&apos;,md5(&apos;newpassword&apos;))) where user_name = &quot;Alex&quot;;{code}&#xD;&#xA;&#xD;&#xA;The default admin username is WikiSysop, with user_id=1, so you could do:&#xD;&#xA;{code}update user set user_password=md5(concat(&apos;1-&apos;,md5(&apos;newadminpassword&apos;))) where user_id=1;{code}&#xD;&#xA;&#xD;&#xA;Here&apos;s how you add a new user:&#xD;&#xA;{code}insert into user(user_name) values (&quot;Alex&quot;);{code} then set a password as above.  Keep in mind that usernames must start with a capital letter.</s:content>
        <s:mTime>2007-06-07 22:08:53.0</s:mTime>
        <s:cTime>2007-06-07 22:08:53.0</s:cTime>
        <s:comments
             rdf:type='http://www.w3.org/1999/02/22-rdf-syntax-ns#Bag'/>
        <s:snipLinks>
            <rdf:Bag>
                <rdf:li>
                    <s:Snip rdf:about='http://bliki.rimuhosting.com/rdf#start/mediawiki+password+reset'>
                        <s:attachments
                             rdf:type='http://www.w3.org/1999/02/22-rdf-syntax-ns#Bag'/>
                    </s:Snip>
                </rdf:li>
                <rdf:li rdf:resource='http://bliki.rimuhosting.com/rdf#start/mediawiki%2bpassword%2breset'/>
                <rdf:li rdf:resource='#snipsnap-search'/>
                <rdf:li rdf:resource='#snipsnap-index'/>
                <rdf:li rdf:resource='http://bliki.rimuhosting.com/rdf#knowledgebase/linux/miscapplications/roundcube'/>
                <rdf:li rdf:resource='#ivan'/>
            </rdf:Bag>
        </s:snipLinks>
    </s:Snip>
</rdf:RDF>
