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