MySQL: SYSTEM_USER Function
This MySQL tutorial explains how to use the MySQL SYSTEM_USER function with syntax and examples.
Description
The MySQL SYSTEM_USER function returns the user name and host name for the current MySQL user.
Syntax
The syntax for the SYSTEM_USER function in MySQL is:
SYSTEM_USER( )
Parameters or Arguments
There are no parameters or arguments for the SYSTEM_USER function in MySQL.
Note
- The user name returned is the name of the user specified when connecting to the server.
- The host name returned is the name of the client host that the user connected from.
- The SESSION_USER and SYSTEM_USER functions are synonyms for the USER function.
- See also the CURRENT_USER function which can return a different value than the SYSTEM_USER function.
Applies To
The SYSTEM_USER function can be used in the following versions of MySQL:
- MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23
Example
Let's look at some MySQL SYSTEM_USER function examples and explore how to use the SYSTEM_USER function in MySQL.
For example:
mysql> SELECT SYSTEM_USER();
This SYSTEM_USER function example would return the user name and host name for the current MySQL user.
So if the user name specified when connecting to the server was 'root' and the name of the client host that the user connected from was 'imac.techonthenet.com:
mysql> SELECT SYSTEM_USER(); Result: 'root@imac.techonthenet.com'
Advertisements