• Navigation
  • Main page
  • Recent changes
  • Random page
  • Help
• Toolbox
  • What links here
  • Related changes
  • Upload file
  • Special pages
  • Printable version
  • Permanent link
  • Print as PDF

Lost admin rights

From EQdkp Plus Wiki

Method 1

• Log into your phpMyAdmin (if you do not know how, ask your web host).
• Choose your database name from the dropdown.
• Press the button that says SQL.

• Input the following:

update eqdkp_auth_users set auth_setting='Y' where user_id in (select user_id from eqdkp_users where username = 'your username');

You would replace "Your Username" with the administrator's username. You could also be using a different table name structure for the prefix.. for example. Instead of "eqdkp_auth_users", you could have "eqdkp1_auth_users. Be sure to change this accordingly.

• So it should look like this:

Press OK again and you should all have rights. Should an error occur, however, try using the 2nd Method.

Method 2

• Log into your phpMyAdmin and select your database, open the SQL window.
• Input the following (replace username):

select user_id, username from eqdkp_users where username like 'your username';

• It will give you the user number of the currently requested user name (usually the'1 '):

• Input the following into the SQL window (if necessary, replace the user number):

update eqdkp_auth_users set auth_setting = 'Y' where user_id ='1 ';

• Click OK and then the rights should be restored again.