Mysql import in myPhpAdmin fails with error 1044
It's a fairly straight forward schema and the sql gets executed to a point. This is the error:
#1044 - Access denied for user 'cpses_iggpvryohb'@'localhost' to database 'phoenix'
Suffice to say that that user doesn't exits, nor do I try to use that user. This appears to be some other process monitoring the database?
The command triggering this appears to be (this is from an auto generated export using HeidiSQL in Windows):
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
`permission_id` bigint(20) unsigned NOT NULL,
`role_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`role_id`),
KEY `role_has_permissions_role_id_foreign` (`role_id`),
CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`)
ON DELETE CASCADE,
CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;