Editing serendiptiy_authors database

[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

[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.

[JamesK]

Garvin,

Thank you for your two responses to my posts. I have Serendipity configured exactly the way I need.

Jim