MySQL 8 and Persona 8 Tuning for WordPress

If you’re running MySQL 8 or Percona 8, then you’ll probably see lots of guides online that reference some out of data configuration that really only deals with functions in MySQL 5 that have been deprecated in MySQL 8 and Percona 8

Query Cache

No longer used, and removed from MySQL 8 and Percona 8, alternative is ProxySQL as per the following Percona article https://www.percona.com/blog/2018/02/07/proxysql-query-cache/

Fix the “The package could not be installed. PCLZIP_ERR_BAD_FORMAT” WordPress Error

This is pretty straightforward, you’ll see this error when updating or installing a plugin.

[enlighter linenumbers=”true”]The package could not be installed. PCLZIP_ERR_BAD_FORMAT[/enlighter]

Basically the file WordPress is trying to download is either corrupt or you don’t have the PHP curl module installed. So simply install it, for Ubuntu this is:

[enlighter linenumbers=”true”]apt-get install php-curl[/enlighter]

or

[enlighter linenumbers=”true”]apt-get install php7.3-curl[/enlighter]

Enable MultiSite on WordPress 3.0 RC1

I was searching around on how to Enable Multisite on WordPress 3.0 RC1 and I couldn’t find anything, and some sites were incorrectly telling you how.

Here is the official instruction’s from WordPress on their Codex site.

http://codex.wordpress.org/User:Andrea/Create_A_Network

All you need to do is add the following code into your wp-config.php

define(‘WP_ALLOW_MULTISITE’, true);