Tag: python

Security, Sysadmin, WordPress

Get WordPress off MySQL root: per-site users in one Python loop

| by admin | Leave a Comment on Get WordPress off MySQL root: per-site users in one Python loop
A single key resting in a locker door, symbolizing per-site database credentials with no shared master key (photo: Jakub Zerdzicki / Pexels)

If you run more than one WordPress site on a single server and every wp-config.php has DB_USER = 'root', your eight sites are effectively one site as far as a compromise is concerned. One vulnerable plugin on any of …

Continue reading "Get WordPress off MySQL root: per-site users in one Python loop"
Sysadmin, Tutorials, WordPress

Recovering a malformed wp_options.active_plugins: the SQL REPLACE() trap and how to rebuild

| by admin | Leave a Comment on Recovering a malformed wp_options.active_plugins: the SQL REPLACE() trap and how to rebuild
A nearly-complete white jigsaw puzzle with one piece sitting outside its slot, exposing the blue surface beneath — visual metaphor for one wrong byte breaking the whole serialized array (photo: Mike Van Schoonderwalt / Pexels)

You have a WordPress site that’s returning HTTP 200, the homepage renders, but something’s quietly off. WooCommerce features aren’t loading. LiteSpeed Cache settings page is empty. The Mailpoet sender isn’t sending. None of these would normally fail at the same …

Continue reading "Recovering a malformed wp_options.active_plugins: the SQL REPLACE() trap and how to rebuild"