Answers for "select user from mysql.user"

SQL
0

mysql current user

-- mysql current user:
SELECT USER();
-- or
SELECT CURRENT_USER();
Posted by: Guest on March-21-2021
1

mysql user

CREATE USER 'pdam'@'localhost' IDENTIFIED BY 'pdamP@ssw0rd'; # create user
GRANT ALL PRIVILEGES ON `pdam_db`.* TO 'pdam'@'localhost'; # set db access
FLUSH PRIVILEGES; # Reload
Posted by: Guest on August-06-2021

Code answers related to "select user from mysql.user"

Code answers related to "SQL"

Browse Popular Code Answers by Language