/SQL/How to check current user in mySQL

How to check current user in mySQL

How to check username in mysql command line

SELECT User, Host FROM mysql.user;

1

Source: linuxize.com

Mysql current user

-- mysql current user:
SELECT USER();

-- or
SELECT CURRENT_USER();

1

How to check current user in mySQL

SELECT USER();

0

Source: stackoverflow.com

Similar codes

15 votes235 views4 answers
How to get all tables in sql
SQL
0 vote240 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote215 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
5 votes243 views2 answers
Mysql import gzip db
SQL
4 votes255 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
-2 votes264 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote221 views1 answer
Pl sql turn off variable substitution
SQL
23 votes243 views1 answer
How remove column in mysql
SQL
2 votes220 views2 answers
Mysql all columns
SQL
0 vote228 views1 answer
Update one column from another column in same table
SQL

Share