Do you know why the admin user is "blocked", or what action caused the admin user to be blocked?

If it's a password problem, you should be able to use the "Forgot Password" link on the login page (assuming you have email working). The UI doesn't support making the logged-in user "inactive", but if this is what happened somehow you can connect directly to the database (using e.g. mysql cli, phpmyadmin, adminer, etc.) and edit/change the status to "1".

If it's a password problem but you don't have email working, connect directly to the database and change the password hash to something known. E.g. for password "secret", use "5ebe2294ecd0e0f08eab7690d2a6ee69".

Good luck,
Dale

Update database, table resource, for line of corresponding user (defaut admin is first one)
Set locked=0
If you loose password
set password='newpassword', crypto=null

Hi,

As of 6.52 I receive the message:

ERROR 1054 (42S22): Unknown column 'isLdpa' in 'field list'

Any suggestion?

Regs.

Mike

Hi,

As of 6.52 I receive the message:

ERROR 1054 (42S22): Unknown column 'isLdpa' in 'field list'

Any suggestion?

Regs.

Mike

I used:

UPDATE resource SET password='newPassword', crypto=NULL, isLdpa=0 WHERE id=1;

field is "isLdap", not "isLdpa"

UPDATE resource SET password='newPassword', crypto=NULL, isLdap=0 WHERE id=1;