Deleted my admin user and pass in wordpress blog

Discussion in 'Databases' started by kewlchat, Sep 29, 2008.

0
  1. #1
    I deleted my admin user and pass in wordpress blog.

    I re added it but it was as normal user and i dont know the right tables to make it admin :eek:

    Anyone tell me what to do to re-add myself as admin in sql or an easy way to do it, i got full access to the website and hosting folder and am the domain owner but i messed up bad i was trying to delete it and add it back but with a new name and didnt do it right it came up as a normal user and i dont know how to fix it..

    its a pr2 site and nice so if any can help me ill rep ya of course and be forever greatfull :)
     
    kewlchat, Sep 29, 2008 IP
  2. Whippet75

    Whippet75 Well-Known Member

    Messages:
    1,599
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    155
    #2
    If you change the ID of the member you have created to No.1 using phpmyadmin, this will give you admin access ;)

    [​IMG]
     
    Whippet75, Sep 29, 2008 IP
    kewlchat likes this.
  3. kewlchat

    kewlchat Well-Known Member

    Messages:
    1,779
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    110
    #3
    Thank you so much +rep added i apreciate it alot :)
     
    kewlchat, Sep 29, 2008 IP