wp-cli: wp db export (Access denied)

Hi all, I have a really strange behaviour of wp db export, see:

mysqldump -h mysql.tt -u bedrock_wp -p bedrock_wp > /tmp/wpcli_database.sql
Enter password: foo

% du -sh /tmp/wpcli_database.sql
340K    /tmp/wpcli_database.sql

works without problems, it dumps the entire DB. When I use wp db export I get:

% wp db export /tmp/wpcli_database.sql
mysqldump: Got error: 1045: Access denied for user 'bedrock_wp'@'192.168.80.1' (using password: YES) when trying to connect

in .env I have:

DB_NAME=bedrock_wp
DB_USER=bedrock_wp
DB_PASSWORD=foo
DB_HOST=mysql.tt

which is fine.

wp-cli.yml just contains path: web/wp cause i use this with bedrock wp stack.

% wp --info
PHP binary: /usr/local/Cellar/php55/5.5.14/bin/php
PHP version:    5.5.14
php.ini used:   /usr/local/etc/php/5.5/php.ini
WP-CLI root dir:    phar://wp-cli.phar
WP-CLI global config:
WP-CLI project config:  /Users/eim/Documents/webdev/development/bedrock/wp-cli.yml
WP-CLI version: 0.14.1

any suggestions? Thanks.

About this issue

  • Original URL
  • State: closed
  • Created 10 years ago
  • Comments: 15 (5 by maintainers)

Most upvoted comments

I was having the same problem and in my case I solved it by removing my login path (client in my case) from mysql_config_editor: mysql_config_editor remove --login-path=client