There is no such grant defined for user
| User, date | Message |
|---|---|
|
Written by gemal
2 years ago Category: General 18 posts since Thu, 14 Oct 10 |
got this error while click in the user management dialog: exception message : SQL Error (1141): There is no such grant defined for user 'root' on host 'hmm.dontwanttodisclose.dk'. ----------- date/time : 2011-05-16, 12:14:23, 812ms computer name : GEMAL user name : Michael <admin> registered owner : Henrik Gemal / DinnerBooking operating system : Windows XP Service Pack 3 build 2600 system language : English system up time : 1 hour 18 minutes program up time : 6 minutes 57 seconds processors : 2x AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ physical memory : 1482/3326 MB (free/total) free disk space : (C:) 10,74 GB display mode : 1440x900, 32 bit process id : $1404 allocated memory : 31,32 MB executable : heidisql.exe exec. date/time : 2011-05-16 10:54 version : 6.0.0.3832 compiled with : Delphi XE madExcept version : 3.0m beta 1 callstack crc : $18ba9f1b, $dff9c2ea, $dff9c2ea exception number : 1 exception class : EDatabaseError exception message : SQL Error (1141): There is no such grant defined for user 'root' on host 'hmm.dontwanttodisclose.dk'. main thread ($1334): 0073c88e heidisql.exe dbconnection 1308 +26 TMySQLConnection.Query 007453cc heidisql.exe dbconnection 3151 +3 TMySQLQuery.Execute 0073e9a5 heidisql.exe dbconnection 1764 +5 TDBConnection.GetResults 0073f334 heidisql.exe dbconnection 1940 +1 TDBConnection.GetCol 0077372e heidisql.exe usermanager 427 +35 TUserManagerForm.listUsersFocusChanged 0063808e heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange 0063c4da heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown 004e95c0 heidisql.exe Controls TControl.DoMouseDown 006347a4 heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown 004e8f68 heidisql.exe Controls TControl.WndProc 004ed82c heidisql.exe Controls TWinControl.WndProc 0064076c heidisql.exe VirtualTrees TBaseVirtualTree.WndProc 004ececc heidisql.exe Controls TWinControl.MainWndProc 004ab73c heidisql.exe Classes StdWndProc 7e418a0b USER32.dll DispatchMessageW 00587443 heidisql.exe Forms TApplication.ProcessMessage 00587486 heidisql.exe Forms TApplication.HandleMessage 00582de5 heidisql.exe Forms TCustomForm.ShowModal 007d254c heidisql.exe Main 1935 +3 TMainForm.actUserManagerExecute 004ab097 heidisql.exe Classes TBasicAction.Execute 004d7755 heidisql.exe ActnList TContainedAction.Execute 004d8510 heidisql.exe ActnList TCustomAction.Execute 004aaf5b heidisql.exe Classes TBasicActionLink.Execute 00508fb8 heidisql.exe Menus TMenuItem.Click 0050a4cb heidisql.exe Menus TMenu.DispatchCommand 00581563 heidisql.exe Forms TCustomForm.WMCommand 004e8f68 heidisql.exe Controls TControl.WndProc 004e8b8c heidisql.exe Controls TControl.Perform 004ed3fb heidisql.exe Controls TWinControl.WndProc 0057e474 heidisql.exe Forms TCustomForm.WndProc 004ececc heidisql.exe Controls TWinControl.MainWndProc 004ab73c heidisql.exe Classes StdWndProc 7e418a0b USER32.dll DispatchMessageW 00587443 heidisql.exe Forms TApplication.ProcessMessage 00587486 heidisql.exe Forms TApplication.HandleMessage 005877b1 heidisql.exe Forms TApplication.Run 007ff89f heidisql.exe heidisql 67 +16 initialization |
|
Written by ansgar
2 years ago 3952 posts since Fri, 07 Apr 06 |
What did you exactly do before you clicked away from that user? Added or changed a grant? |
|
Written by gemal
2 years ago 18 posts since Thu, 14 Oct 10 |
I think I changed user from 127.0.0.1 to local host using the query not sure |
|
Written by ansgar
2 years ago 3952 posts since Fri, 07 Apr 06 |
Hm I can't get that reproduced that here. Would be nice if you post the relevant commands from the SQL log here, next time you get that error. |
|
Written by ansgar
1 year ago 3952 posts since Fri, 07 Apr 06 |
See here - found out that the above error is caused by non-flushed users. Fixed that in r4101. |
|
Please login to leave a reply, or register at first. |