ERROR 1046 (3D000): No database selected mysql Erro

Question

enter image description here Under syntax is correct or wrong!! please help .. GRANT ALL PRIVILEGES ON summy-database.* TO 'sammy'@'localhost' IDENTIFIED BY 'password';

Answer 1

I think the problem is the - in the database name, in order to make that work you have to escape it with backticks.

Ex:

GRANT ALL PRIVILEGES ON `summy-database`.* TO 'ammy'@'localhost';