Best way to allow user to create a table

1. What privilege should a user be given to create tables?
2. How to grant CREATE TABLE privileges to user in MySQL?

What privilege should a user be given to create tables?

What privilege should a user be given to create tables? TheCREATETABLEprivilege3.

How to grant CREATE TABLE privileges to user in MySQL?

To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';