Generic mysql permission stuff (mostly for Wordpress)

mysql.txt

connect:
 sudo mysql --user=root

Show users and where they can connect from:
 SELECT user,host FROM mysql.user;

Show user-specific privileges:
 SHOW GRANTS FOR 'user'@'192.168.x.xx';

Update user privileges:
 GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON `thisismydatabasename`.* TO `user`@`192.168.x.xxx`;

Persist changes (may be unnecessary)
 flush privileges;