Wordpress Multisite
Functionality notes for Super Administrators
Great user’s manual here.
-
There is
My Sites / Network Admin
submenu on top, but it is only visible when you are inside main network site, not in the additional sites. -
To add new user normally, you must set one option:
Settings > Network Settings > Allow site administrators to add new users...
To get there, go this route:My Sites / Network Admin / Dashboard
Database & SQL Queries
Detailed explanation of WP Multisite database tables.
List (or delete) users:
SELECT * FROM `wp_usermeta` WHERE user_id IN (3,5) AND (meta_key LIKE '%capabilities' OR meta_key LIKE '%user_level')
Too add a user in a blog with ID 3, execute this:
INSERT INTO wp_usermeta(user_id,meta_key,meta_value) VALUES(3, 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO wp_usermeta(user_id,meta_key,meta_value) VALUES(3, 'wp_user_level', 10);
- hostingtipp.com, SSL by Let’s Encrypt
etaktiker_admin 75gfDgTGDjyfs5c6
One solution: WordPress Network: Cookie error when using different domains − Blog | CaerCam.org
I solved a cookie problems by puting some custom code in
wp-config.php
.
To add some user as Super Admin
In the wp_sitemeta
table, I added myself to the serialized array of
users in the site_admins option.
Note that the site_admins
meta is case sensitive on username.
SELECT * FROM wp_sitemeta WHERE meta_key = 'site_admins'
Go to online serializator
and enter ["etaktiker_admin", "michaeln"]
. Result in a form
a:2:{i:0;s:15:"etaktiker_admin";i:1;s:8:"michaeln";}
run as SQL
UPDATE wp_sitemeta
SET meta_value = 'a:2:{i:0;s:15:\"etaktiker_admin\";i:1;s:8:\"michaeln\";}'
WHERE meta_key = 'site_admins';