Mysql import in myPhpAdmin fails with error 1044

Avatar
  • updated
  • Answered

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;

Pinned replies
Avatar
Alyssa K
  • Answer
  • Answered

Hello Sven,

Thank you for your question and the follow-up! We are glad to see that the issue was resolved. Please let us know if you have any additional questions.

Best Regards,

Alyssa K

Avatar
Alyssa K
  • Answer
  • Answered

Hello Sven,

Thank you for your question and the follow-up! We are glad to see that the issue was resolved. Please let us know if you have any additional questions.

Best Regards,

Alyssa K

Avatar
SvenTheGrinch

Figured it out... it was... "me". I didn't add the prefix for my database to the "use" statement, so the real error was that no database was selected. Not sure why this random user get's thrown out as part of the error message, but that was immaterial