mySQL equivalent of `whoami`?

[sfullman]

Is there an equivalent way of saying linux 'whoami' in mysql?

Thanks!

[nnichols]

You can use "SELECT USER();" which will return "user@host".

To get just the user_part use -

SELECT SUBSTRING_INDEX(USER(),"@",1);

Hope this helps 😉