In Oracle, the USER function returns the name of the session user. In MySQL, you can use the USER() function.
Oracle:
-- Get the current user SELECT USER FROM dual;
MySQL:
-- Get the current user SELECT USER();
For more information, see Oracle to MySQL Migration.