MySql can't create user

116 Views Asked by At

I'm logged in as root using the MySQL command line on windows. This was installed with Microsoft Web Platform Installer. Version is

Server version: 5.1.72-community MySQL Community Server (GPL)

I can't create a new user with this statement

create user 'someuser'@'localhost' indentified by password 'somepassword';

or

create user 'someuser'@'localhost' indentified by 'somepassword';

I get this 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 'inden
tified by 'somepassword'' at line 1
1

There are 1 best solutions below

0
On BEST ANSWER

There is a typo: indentified which should be identified