Create new database user maria with all privileges and grant option
DROP USER IF EXISTS 'maria'@'localhost';
DROP USER IF EXISTS 'maria'@'%';
CREATE USER 'maria'@'localhost' IDENTIFIED BY 'P@ssw0rd';
CREATE USER 'maria'@'%' IDENTIFIED BY 'P@ssw0rd';
GRANT ALL PRIVILEGES ON . TO 'maria'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO 'maria'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SELECT USER();
SHOW GRANTS \G;
-- Show users in the database
USE mysql;
SELECT user, host FROM user ORDER BY user;