I'm trying to get with a simple SQL statement the IP address of the client. I do not want to use PHP or other techniques. Only pure SQL. When I use
SELECT USER();
I get
dbouser@host.i.do.not.care.of
When I use
SELECT CURRENT_USER();
I get
dbouser@%
But how do I get the plain IP? Thanks a lot in advance.
See Question&Answers more detail:os