Give Movable Type User System Admin Rights via MySQL

| No Comments
  1. login to mysql

    $ mysql -u USERNAME -p DATABASENAME
    
  2. find id of user

    > select author_name, author_id from mt_author;
    +---------------+-----------+
    | author_name   | author_id |
    +---------------+-----------+
    | beau          |         1 |
    | quinn         |         2 |
    | ryan          |         3 |
    | jono          |         4 |
    +---------------+-----------+
    
  3. issue the command using the correct author id from the table

    > update mt_author set author_is_superuser = 1 where author_id = 1;
    

Leave a comment

About this Entry

This page contains a single entry by Beau Smith published on April 2, 2008 5:14 PM.

Reset Password for Movable Type User via MySQL was the previous entry in this blog.

Scrolling Preformatted Code Examples is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

OpenID accepted here Learn more about OpenID
Powered by Movable Type 4.21-en