Cannot import database dump: Access denied for user 'user'@'localhost' to database 'database'

Symptoms

• Cannot import a database dump:

  PLESK_ERROR: Unable to import the 'database_name' dump:
  ERROR 1044 (42000) at line 21: Access denied for user 'user'@'localhost' to database 'database'
  Traceback (most recent call last):
  File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
  File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
  restore(options, password)
  File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
  raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
  Exception: program 'mysql' finished with non-zero exit code: 1

• The dump is being imported under an existing user that already manages other databases.

• The database is absent on the server

Cause

Database dump contains permissions issued for another user that was utilized on a previous server.

Resolution

Re-create the dump on the source, exporting only database tables and import the dump again.