{{tag>mysql mariadb wordpress sql}}

====== Wordpress sql user privileges ======

<code sql>
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';
</code>
====== Tested on ======


====== See also ======
  * [[wiki:wordpress_nginx|Wordpress on nginx]]
  * [[wiki:wordpress_permissions|Wordpress permissions]]
  * [[wiki:wordpress_php_plugins|Wordpress php plugins]]

====== References ======