8 lines
336 B
SQL
8 lines
336 B
SQL
-- Create user and grant privileges for MariaDB
|
|
CREATE USER IF NOT EXISTS 'omron'@'localhost' IDENTIFIED BY 'Initial01!';
|
|
GRANT ALL PRIVILEGES ON cantare_injectie.* TO 'omron'@'localhost';
|
|
FLUSH PRIVILEGES;
|
|
|
|
-- Show the user and their privileges
|
|
SELECT User, Host FROM mysql.user WHERE User='omron';
|
|
SHOW GRANTS FOR 'omron'@'localhost'; |