0

I know this question's been asked already a million times, but I can't connect my database to my back-end in Java. How do I solve this?

I tried to grant all the permissions using this syntax:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' 
WITH GRANT OPTION;

both in MySQL Workbench and even from command line, but I get the following errors:

Workbench

Terminal

I use windows 11.

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
marcom966
  • 1
  • 1
  • The `identified by ''` part doesn't belong in this statement, see [13.7.1.6 GRANT Statement](https://dev.mysql.com/doc/refman/8.0/en/grant.html). You seem to have combined two different solutions into one statement. – Mark Rotteveel Feb 10 '23 at 11:31

0 Answers0