distal-attribute
distal-attribute
distal-attribute
distal-attribute

There is no such grant defined for user

User, date Message
Written by gemal
3 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
3 years ago
4938 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
3 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
3 years ago
4938 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
2 years ago
4938 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.