Local Community

Wp db reset doesn't work correctly with MySQL

Bug Summary

When trying to reset a site using WP CLI I get this error:

$ wp db reset
Are you sure you want to reset the 'local' database? [y/n] y
Error: Failed to get current SQL modes. Reason: '"mysql --no-defaults --no-auto-rehash --batch --skip-column-names --execute="SELECT' is not recognized as an internal or external command,
operable program or batch file.

This is NOT related to: Wp db reset – Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) - Bugs - Local Community (localwp.com)

Steps to reproduce

Open site shell and try to reset the site.

Environment Info

Describe your environment.

  • What Operating System are you using?
    Windows 10 Pro 21H2
  • What versions of site software (Nginx, Apache, PHP, MySQL) is used?
    PHP 8.0, nginx, MySQL 5.7.28
  • What version of Local is installed?

Supporting info

Please provide your Local Log. See this Community Forum post for instructions on how to do so:

local-lightning.zip (75.8 KB)