I recently granted ALTER access in MySQL so a user
could run the ALTER TABLE command . However after I
granted the necessary privileges, the user was still not able to
perform the tasks needed. Reproducing the issue using a test
instance, I granted a test user the required privileges and MySQL
reported no errors or warnings when the ALTER TABLE
was run:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.1.41-log MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant alter,create,insert on *.* to 'test'@localhost; Query OK, 0 rows affected (0.00 sec) mysql> show warnings; Empty set (0.00 sec) mysql> show errors; Empty set (0.00 sec) mysql>
The reason I granted the addition CREATE and
INSERT privileges is that according to the MySQL
documentation ( …