How to create super admin via db?

Question

PHP

The site has multisite enabled, and the super admin has been removed. Now there is a need to create a new super administrator. I thought in some way through the database to add, but maybe there are other options?

Answer 1

in the database in the wp_users table. Do not forget when you set the password to put - MD5 encryption.

Answer 2

There is also wp_usermeta... The roles are set there.
The keys wp_capabilities and wp_user_level
I would suggest to quickly deploy a separate WP with multisite and look at the values ​​for these keys.
The following is the order.
In wp_users create a new entry, fill in the data. Leave the password blank. Get user_id
In wp_usermeta:
user_id from the previous point, meta_key - wp_capabilities, meta_value - from a separate WP.
user_id , meta_key - wp_user_level, meta_value - from separate WP (I suspect 11).
Set a new password through password recovery and log in.
Should work