WP-CLI Command Error: Reason: /usr/bin/env: ‘mysql’: No such file or directory

evandrobm15

I have always run WP-CLI commands in WordOps normally, but after these latest WordOps updates they no longer work.

Example:
wp db reset --yes --allow-root
wp db import banco.sql --allow-root
wp db export banco.sql --allow-root

Any of the above commands will return an error similar to:

Error: Failed to get current SQL modes. Reason: /usr/bin/env: ‘mysql’: No such file or directory

I saw some possible solutions on the internet, because as a layman I would like a better solution so that it doesn't harm any other service in the functioning of WordOps.

evandrobm15

With more research and AI I managed to solve it as follows:

I created symbolic links for WP-CLI to call MariaDB instead of MySQL with the following commands:

MySQL:

sudo ln -s /usr/bin/mariadb /usr/bin/mysql

MySQLDUMP:

sudo ln -s /usr/bin/mariadb-dump /usr/bin/mysqldump

So I ran the commands and WP-CLI worked.