Workbench > Mysqldbcopy --Need CREATE permission on Destination remote server

[Alban F]

Hi Mysql Guru,

I have tried to copy one database from my local server to a remote server using Workbench > mysqldbcopy utility.
Command used :

mysqldbcopy databasetocopy:C--source=user1:pw1@localserver:3306 --destination=user2:pw2@remoteserver

I have an error message saying that the user user2 on the destination server does not have permissions to create all objects in copyofdatabasetocopy. User need CREATE privilege on copyofdatabasetocopy.

I checked that user2 have these permissions. It seems to have as I tested to log with it via phpAdmin and create a table in the copyofdatabasetocopy database... It worked fine !

Any idea Guru ?

Many thanks

Alban