Why is GRANT not working in MySQL?

What you are selecting are the global privileges. You are however giving database (and host, but that doesn’t matter) specific privileges. GRANT INSERT ON wordpress.* TO ‘www’@’localhost’ IDENTIFIED BY ‘basic’; These permissions are stored in the db table. Just to point you in the right direction: SHOW GRANTS FOR ‘www’@’localhost’ http://dev.mysql.com/doc/refman/5.0/en/show-grants.html

Remove privileges from MySQL database

The USAGE-privilege in mysql simply means that there are no privileges for the user ‘phpadmin’@’localhost’ defined on global level *.*. Additionally the same user has ALL-privilege on database phpmyadmin phpadmin.*. So if you want to remove all the privileges and start totally from scratch do the following: Revoke all privileges on database level: REVOKE ALL …

Read more

Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)

Assuming by full dump you also mean the VIEWs and the EVENTs, you would need: GRANT USAGE ON *.* TO ‘dump’@’%’ IDENTIFIED BY …; GRANT SELECT, LOCK TABLES ON `mysql`.* TO ‘dump’@’%’; GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON `myschema`.* TO ‘dump’@’%’; and if you have VIEWs that execute a function, then unfortunately …

Read more

Postgresql: error “must be owner of relation” when changing a owner object

Thanks to Mike’s comment, I’ve re-read the doc and I’ve realised that my current user (i.e. userA that already has the create privilege) wasn’t a direct/indirect member of the new owning role… So the solution was quite simple – I’ve just done this grant: grant userB to userA; That’s all folks 😉 Update: Another requirement …

Read more