Bug #31819 root and USER_NAME with globabl priviledges not the same in 5.1.22rc ed.
Submitted: 24 Oct 2007 16:44 Modified: 28 Nov 2007 12:30
Reporter: Bill Angus Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.22rc OS:Windows (create schema from backup, not possible unless signed on as root)
Assigned to: CPU Architecture:Any

[24 Oct 2007 16:44] Bill Angus 
Description:
When using a restore-from-backup with MySQL administrator (or using any other agent-utility that creates/recreates/copies a schemata as well as tables and indices wihtin schema) the restore fails unless the user is signed on as root. Only root can recreate the schema as well as tables within the schema.

How to repeat:
If signed on as a (non-root) user with all global priviledges enabled (i.e. create schema .... supposed to be equivalent to root), try to restore from backup into an install that does not already contain the schema you are restoring. A failure error occurs and the schema cannot be created.
[28 Oct 2007 12:30] Valeriy Kravchuk 
Thank you for a problem report. Please, send your problematic schema. Does it have any SPs/triggers created as root?
[29 Nov 2007 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".