I have such a mistake
mysql>create database vsearchlogDB;
ERROR 1007 (HY000): Can't create database 'vsearchlogdb'; database exists
mysql> 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
the program tells me that the syntax is incorrect. I don’t know what the problem is. I study everything by the book:
Paul Barry
HEAD FIRST PYTHON
and the book itself is a little outdated, but still relevant