Allow user to create and alter table?

Question

I have a current mysql user who has SELECT privileges for all the table in database example. How can give that user privileges to add new tables, and alter/add records to the table it created?

Answer 1

Use the grant keyword combined with the table privileges you seek to give the user.

GRANT ALTER, CREATE ON example TO 'someuser'@'somehost';

MySQL Grant

MySQL Table Privileges