CREATE DATABASE wordpress;

SHOW DATABASES;


CREATE USER 'user2'@'localhost' IDENTIFIED BY 'pwd';

SELECT user FROM mysql.user;


GRANT ALL ON wordpress.* TO 'user2'@'localhost';

SHOW GRANTS FOR 'user2'@'localhost';


FLUSH PRIVILEGES;

EXIT;