Hi,

I've been trying to sync my staging database to my dev (local) with the following command:

drush sql-sync @stage @dev --create-db

but keep getting the following error:

You will destroy data in dbname and replace with data from hostname/dbname.

You might want to make a backup first, using the sql-dump command.

Do you really want to continue? (y/n): y
ERROR 1044 (42000) at line 1: Access denied for user 'username'@'localhost' to database 'dbname'
ERROR 1044 (42000) at line 39: Access denied for user 'username'@'localhost' to database 'dbname'

I have checked and rechecked my site aliases to make sure the passwords, dbnames etc are valid. I don't have wildcards in my local password either. What could be causing this? I am able to rsync the sites using the aliases. So not sure whey the databases can't be.

Any help appreciated on this as it would cut alot of time out for me if I can sql-sync the databases via drush.

Thanks :)

Comments

greg.1.anderson’s picture

Version: 7.x-5.8 » 8.x-6.x-dev
Status: Active » Closed (won't fix)
Issue tags: +Needs migration

This issue was marked closed (won't fix) because Drush has moved to Github.

If you still need help, please ask your question again on Drupal Answers and then post a link here to the new question. Please also change the status of this issue to closed (duplicate).

Use our Github project for contributing code, or reporting bugs, or requesting features.