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;
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;