I’m getting a 1064 syntax error when trying to create a new user. I’m on windows 10, using python. What I’ve entered at the command line after creating the database is: grant all on vsearchlogDB.* to ‘vsearch’ identified by ‘vsearchpasswd’ ; I’m following Head First Python 2nd edition and this is on page 287. The error I get is that this is a syntax error and it is having trouble with the identified by ‘vsearchpasswd’ ; part of the code. I’m using the latest version of mysql for Windows
Apologies, I think that was because I posted from my phone. I’ve added the code direct from the command prompt now, still having the error shown below:
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