mysql> select user(); +-------------------+ | user() | +-------------------+ | [EMAIL PROTECTED] | +-------------------+ mysql> show grants for [EMAIL PROTECTED]; ERROR 1141: There is no such grant defined for user 'root' on host '192.168.0.17'
mysql> show grants for user(); ERROR 1064: You have an error in your SQL syntax near 'user()' at line 1 mysql> select user,host from mysql.user where user='root'; +-------+---------------------------+ | user | host | +-------+---------------------------+ | root | % | | root | 192.168.0.0/255.255.255.0 | | root | localhost | +-------+---------------------------+ in theory i should be logged in [EMAIL PROTECTED]/255.255.255.0, but i've been wrong before... is there a way to just get which user/host set is being used? On Monday 03 June 2002 9:28, you wrote: > Hi Ray, > > You can see what user you is with: > select user(); > > Ray wrote: > >is there a show grants self or a whoami type command? > > > >i'm trying to setup security, but i'm not show who i'm login in as? > >root@% or [EMAIL PROTECTED]/255.255.255.0 > > > >i am logging in just fine, but i don't really want to delete root@% until > > i know i'm getting the right login. > > > >\s just shows me > >Current user: [EMAIL PROTECTED] > >but "show grants for [EMAIL PROTECTED];" says there are no grants for this > >account. > > > >also, i could see this coming up for debugging as a big help. > > > > > >note: all ips and usernames have been changed to protect the incredably > >insecure, and maybe a bit paranoid. > > > >sql,query > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > > <[EMAIL PROTECTED]> Trouble > > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- The best cure for insomnia is to get a lot of sleep. -- W. C. Fields --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php