-3

When I try to connect database at the moment I got this an error:

GRANT ALL PRIVILEGES ON `simple_development`.* TO 'rails_user'@'localhost'  IDENTIFIED BY 'PASSWORD';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near IDENTIFIED BY "Password" at line 1

Holger Just
  • 52,918
  • 14
  • 115
  • 123
Gediyaj
  • 13
  • 5
  • 1
    Hello, you need to post a more detailed question if you expect asnwers, for example, the code that is giving you the error. – Viktor May 22 '18 at 10:29
  • Doesn't even worth asking "what is your question?". – sawa May 22 '18 at 10:51

1 Answers1

0

Look at this: "IDENTIFIED BY 'password'" in MySQL

"

In summary, use CREATE to create a user, and use GRANT to add privileges:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';

"

SEGV
  • 848
  • 1
  • 8
  • 19
  • Yes its works but now when i try to : – Gediyaj May 22 '18 at 12:08
  • Ok Thanks its works but now when I try to type the following command: rails db:schema;dump that time getting this error: rails aborted! Mysql2:Error: Authentication plugins ' caching_sha2_password' cannot be loaded: the specified module could not be found bin/rails:4:in '
    '
     – Gediyaj May 22 '18 at 12:12