For When You Can't Have The Real Thing
[ start | index | login ]
start > mysql > whoami

whoami

Created by dave. Last edited by dave, 306 days ago. Viewed 358 times. #1
[edit] [rdf]
labels
attachments
(2023-05-02)

I'm logged into mysql. Who am I?

You can use the CURRENT_USER and USER functions as follows:

SELECT CURRENT_USER();
SELECT USER();
CURRENT_USER shows who you are authenticated as, while USER shows who you tried to authenticate as.
no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:


snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt