CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
 
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,LOCK TABLES ON database_name.* TO 'user'@'localhost' IDENTIFIED BY 'password';
 
FLUSH PRIVILEGES;
 
SHOW GRANTS FOR 'user'@'localhost';

• Wordpress on nginx
• Wordpress permissions
• Wordpress php plugins