1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Create a new user in MySQL/FTP

Discussion in 'XenForo Questions and Support' started by sikkens1997, Apr 3, 2014.

  1. sikkens1997

    sikkens1997 Member


    I would like to create a new user account (and make it super admin) through either FTP or MySQL. So not in the website control panel itself.

    Is this possible?

    Thank you.
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    You shouldn't create users by directly manipulating the database. Once you register as the user or create the user in the ACP and give it the necessary admin permissions, you'll need to edit the config.php file to add the user to the super admins array.
  3. sikkens1997

    sikkens1997 Member

    Is there any way to register without accesing the site, or bypassing the discouraged users?

    The problem is that I can not acces the site, some kid decided to start trolling and he blocked me out of the site. He has a redirect 100% chance link for discouraged users, so I just keep getting redirected places. I can't register like this.

    I do have acces to everything else, just can't enter the forums or I get redirected....
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Is it your site?
  5. sikkens1997

    sikkens1997 Member

    Yes. I am the owner of the XenForo license aswell as the owner of the webhosting.
  6. Brogan

    Brogan XenForo Moderator Staff Member

    You said you still have access to everything else, so you could use phpMyAdmin to manipulate your user record back to a valid state, while at the same time making that user discouraged, etc.
    You can also edit config.php to remove them as a super admin, meaning they can no longer edit other administrators.

    Then you can log in and sort it out.
  7. sikkens1997

    sikkens1997 Member

    Could you please tell me how I can manipulate a new user? I believe he completely removed my account, so I would have to create a new user. I am not very familiar with editing MySQL so I have no clue how to do this.
  8. Liam W

    Liam W Well-Known Member

    This is why you should never have additional super admins.

    An easy way to do it would be to go to phpmyadmin, change the email of this user to your email and then request a password reset for it.

    Then login and ban their IP...
  9. sikkens1997

    sikkens1997 Member

    Yeah, he was a trusted member and he was helping me on the site... Really did not expect this from him.

    I am still discouraged tho, so I can not acces the site. How do I get rid of that discouragement?
  10. Liam W

    Liam W Well-Known Member

    If it is IP based, just use a proxy.
  11. sikkens1997

    sikkens1997 Member

    I've got control back over the site and got rid of the troller.

    Thanks for all the help.

Share This Page