Add a wiki database

From Organic Design wiki
Revision as of 20:03, 21 November 2008 by Nad (talk | contribs) (oops wasn't mpved from tmp)
Procedure.svg Add a wiki database
Organic Design procedure

You need to log in to the database directly. Then obtain the user's id as in the following example:

    SELECT user_id FROM prefix_user WHERE user_name='user';

Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222):

    UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;