Page 1 of 1
Editing serendiptiy_authors database
Posted: Thu Jul 01, 2004 6:38 am
by JamesK
As in the previous post from khrome, I would like to change the administrator name and password after installation. I presume the db file to be edited is serendipity_authors. I really don't have any expertise with MySQL, can you provide some help or a script to make the change? I have a graphical interface phpMyAdmin 2.2.3 available to me, but I can't quite work out how to make the change using it either. Thanks
Re: Editing serendiptiy_authors database
Posted: Thu Jul 01, 2004 1:13 pm
by garvinhicking
Use this SQL:
UPDATE serendipity_authors SET password = MD5('YourNewPassword'), username = 'YourNewUsername' WHERE authorid = 1;
In phpMyAdmin you can first click on your database in the left screen, and then on the top right screen click on "SQL". There you can paste your code.
Regards,
Garvin.
Posted: Fri Jul 02, 2004 1:03 am
by JamesK
Garvin,
Thank you for your two responses to my posts. I have Serendipity configured exactly the way I need.
Jim