is there a whoami for mysql?
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
Re: is there a whoami for mysql?
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 -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - 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
Re: is there a whoami for mysql?
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
