Error on MySQL 8

[wp-cli]

Error on MySQL 8

[dotancohen]

The problem is that MySQL client 8 cannot dump from MySQL server 5.x. The bug is filed here:
https://bugs.mysql.com/bug.php?id=89825

The workaround is to disable column statistics, which relies on 8.x:

$ wp db export --column-statistics=0

[dotancohen]

I can confirm this issue on another Mac:

$ php -v | grep built
PHP 7.1.20 (cli) (built: Jul 20 2018 10:27:12) ( NTS )

$ wp --version
WP-CLI 1.5.1

// From" About This Mac" dialogue:
  Model Name:	MacBook Pro
  Model Identifier:	MacBookPro12,1
  Processor Name:	Intel Core i5
  Processor Speed:	2.7 GHz
  Number of Processors:	1
  Total Number of Cores:	2
  L2 Cache (per Core):	256 KB
  L3 Cache:	3 MB
  Memory:	8 GB
  Boot ROM Version:	MBP121.0177.B00
  SMC Version (system):	2.28f7

[swissspidy]

Have you tried running mysql_upgrade? This should make sure the database is properly upgraded and that the needed tables are created.

[swissspidy]

There also seem to be some incompatibilities with MySQL 8 and PHP 7.2.8. A possible workaround for now — if mysql_upgrade didn't help — is adding this to your MySQL config:

[mysqld]
default-authentication-plugin=mysql_native_password

[wojsmol]

@swissspidy Other option is something like this

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

[jacklowrie]

I'm working on this in #71

[schlessera]

Closed via #71