Issue Accidentally deleted Admin user form DB

[Bogdan1]

Hi,

I accidentally deleted admin user, and now can't access the admin panel.
Is it possible to recreate this user with all privileges?
I tried it with skip-grant-tables in my.cnf but getting this error:

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';
ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

Also tried this: Unable to access Plesk on Linux: Access denied for user 'admin'@'localhost' (using password: YES)

Automatic

But still can't access the admin panel

Zend_Db_Adapter_Exception
SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)

But for some reason I can do this:

[root@host tmp]# mysql -u admin -p
MariaDB [(none)]> use mysql;
Database changed

MariaDB [mysql]>

 

[Brujo]

and if you try to add an additional Admin User via comandline?
admin_alias: Additional Administrator Accounts

 

[Bogdan1]

and if you add from comandline an additional Admin User?
admin_alias: Additional Administrator Accounts

Getting an error:

[2018-04-20 13:29:22.277] ERR [panel] Cannot load settings: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)
SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)
exit status 3

 

[Bogdan1]

Also tried to generate new link /usr/local/psa/bin/admin --get-login-link with skip-grant-tables
but didn't help, same error -_-

 

[Brujo]

what about manualy restore backup of database?
otherwise plesk should do also daily dumps, on a centos there are located at /var/lib/psa/dumps/

see also: How to backup/restore a Plesk database dump?

I suggest that you read carefully what you are doing

 

[Bitpalast]

Restoring from a dump will not work, because it requires Plesk to have access to the database. A manual database import will fail, too, because this requires root access to the database, too. Plesk cannot access the database when the root (admin) record is missing.

I think you should instead stop the MySQL service (MariaDB service), then use the --skip-grant-tables option when restarting it to be able to access the database at all. This will allow you to log in to the database without a password. From there you can add a new admin user, then restart the MySQL (MariaDB) service without --skip-grant-tables again. See a simple guide in How to set, change, and recover a MySQL root password (section "Recover your MySQL password"), but use "admin@localhost" instead of "root@localhost" when resetting it.