无法在mysql中创建新用户
问题描述:
我正在尝试在MySQL 5.6中创建新用户,但在执行查询时出现错误。请帮忙。无法在mysql中创建新用户
mysql> create user [email protected]'%' indentified by 'Passw0rd';<br></b>
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 'Passw0rd'' at line 1
答
CREATE USER 'dsuser'@'%' IDENTIFIED BY 'Passw0rd';
不要忘记在你的用户名引号为好。
该关键字拼写为**'IDENTIFIED' **,而不是**'INDENTIFIED' **。 – spencer7593 2015-02-09 06:32:06