Answers for "mariadb show grants for user"

SQL
0

mariadb check users

-- User only: 
	SELECT User FROM mysql.user;
-- User + Host:
	SELECT host, user FROM mysql.user;
Posted by: Guest on May-11-2021
2

create database and grant user rights mariadb

create database [DB name];

CREATE USER '[DB_User_Name]'@'localhost' IDENTIFIED BY '[DB_Password]';
GRANT ALL PRIVILEGES ON [DB_Name].* TO '[DB_User_Name]'@'localhost';

show grants for 'demouser'@'localhost';

FLUSH PRIVILEGES;
Posted by: Guest on March-22-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language