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)
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