User or database already exists: Operation CREATE USER failed

PolicePing

Trying to migrate and there was a server problem, migration failed was able to just migrate again to old server however when I try to migrate again, the DB part fails.

Provisioning error: Error { kind: AlreadyExists, detail: Some("website"), msg: Some("User or database already exists: Operation CREATE USER failed

When I look at /var/www, I see the site folder and also another site's folder that somehow is still on the server even though it was migrated.
Where would the mysql data be at and is it ok to delete the old unused folders?

Thanks 🙂

Adam

You can drop the conflicting user on the destination server by running:

mysql -e "drop user conflicting_user@localhost;"

The username being in the error message you received when the transfer failed. Repeat for any other conflicts.