Wordpress Multisite

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';
date 01. Jan 0001 | modified 17. Jan 2023
filename: WordPress - Multisite