MySQL Forums
Forum List  »  Newbie

ERROR 1064 (4200) when trying to create a new user
Posted by: Laura King
Date: March 23, 2020 03:09PM

Hello,

I am trying to create a new database to use with OrthoMCL. I have created the database and need to create a user to grant privileges to. I attempted to create a user and password using the code:
> CREATE USER 'orthomcl'@'localhost' INDENTIFIED BY 'password';

I get the error:

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 'INDENTIFIED BY 'password'' at line 1

I was wondering if anyone could please let me know what I am doing wrong and what I need to do to fix this. I am brand new to MySQL and only got mine up and running today. My goal is to get this to work with OrthoMCL.

Thank you,

Laura

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1064 (4200) when trying to create a new user
March 23, 2020 03:09PM


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.