Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MySQL USER() Function

Concept visual

MySQL USER() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current user name and host name for the MySQL connection:

SELECT USER();

Definition and Usage

The USER() function returns the current user name and host name for the MySQL connection.

Note:

This function is equal to the

SESSION_USER() function and the SYSTEM_USER() function.

Tip:

Also look at the

CURRENT_USER() function.

Syntax

User()

Technical Details

Works in:

From MySQL 4.0

MySQL USER() Function

Concept visual

MySQL USER() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current user name and host name for the MySQL connection:

SELECT USER();

Definition and Usage

The USER() function returns the current user name and host name for the MySQL connection.

Note:

This function is equal to the

SESSION_USER() function and the SYSTEM_USER() function.

Tip:

Also look at the

CURRENT_USER() function.

Syntax

User()

Technical Details

Works in:

From MySQL 4.0

MySQL USER() Function

MySQL USER() Function

Example

Definition and Usage

Note:

This function is equal to the

Tip:

Also look at the

Syntax

User()

Technical Details

Works in:

Previous

Next

MySQL USER() Function

MySQL USER() Function

Example

Definition and Usage

Note:

This function is equal to the

Tip:

Also look at the

Syntax

User()

Technical Details

Works in:

Previous

Next