Following command provides all privilege in all databases for User 'admin'. But it doesn't allow 'admin' to create database.
GRANT ALL ON * . * TO 'admin'@'localhost';
How can I provide the access for 'admin' to create database?
As I am trying to Create database, I am getting the following error -
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'newdb'