how to grant a user permission to create databases? I use phpMyAdmin powered by Mamp (free version) to manage Mysql databases.

I need to know how to grant a user permission to create databases.
Try this command

GRANT CREATE ON *.* TO 'user'@'host';


For further information, please see MySQL Documentation on GRANT syntax