how to grant a user permission to create databases?

Question

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.

Answer 1

Try this command

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

For further information, please see MySQL Documentation on GRANT syntax