enter image description here Under syntax is correct or wrong!! please help .. GRANT ALL PRIVILEGES ON summy-database.* TO 'sammy'@'localhost' IDENTIFIED BY 'password';
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';
2.1m questions
2.1m answers
60 comments
56.6k users