MySQL Forums
Forum List  »  Install & Repo

Ceation of DB, creation of user, pb with GRANT ALL PRIVILEGES
Posted by: jonathan zerbib
Date: November 29, 2019 08:13AM

Hello there!!

I just created a db.
Then I wanted to use this:
GRANT ALL PRIVILEGES ON mybase.* TO 'NewUser'@'localhost' IDENTIFIED BY 'NewPassword';

and then, 1064 syntax error.

Have I to do it by two steps: CREATE USER, and then GRANT PRIVILEGES?

THank you in advance!!
Jonathan

Options: ReplyQuote


Subject
Written By
Posted
Ceation of DB, creation of user, pb with GRANT ALL PRIVILEGES
November 29, 2019 08:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.