在输入>grant all on vsearchlogDB.* to 'vsearch' identified by 'vsearchpasswd'; 就提示ERROR 1064 (42000):

我在mysql中输入>create database vsearchlogDB;成功后
在输入>grant all on vsearchlogDB.* to 'vsearch' identified by 'vsearchpasswd';
就提示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 'vsearchpasswd'' at line 1

求解惑！

正确的是：grant all privileges on vsearchlogDB.* to 'vsearch'@'localhost' identified by 'vsearchpasswd';