mySQL export issue

Developer help
1

Hi,

I followed the instructions to upgrade to version 6 using the migration script but every time I get the same error message: The provided user doesn’t have sufficient privileges for database export.

I’ve tried with the root user, with the newly created user granted SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER privileges, with a user GRANT ALL PRIVILEGES and still the same message… HELP PLEASE :shaking_face:!!!

1 Like
2

Hello!

I have the exact same issue when trying to migrate from Ghost CLI to the docker version. The migration script tells me my sql user doesn’t have enough permission to export the current database.

I’ve tested with the mysql root user, which should all all privileges. And I’ve tried login in mysql manually as root to make sure I had the correct credentials, which works.

I’ve also tested my current mysql user used by the cli version of Ghost, same error.

Not sure what to do next here as the script doesn’t give much more options.

Have you figured it out @Johann ?

Thanks!