Hello group & happy New Year,
I have a two-line script that's failing with error 1064:

CREATE USER 'LinqUser'@'%';
SET PASSWORD FOR 'LinqUser'@'%' = PASSWORD('linq2');

Result:
You have an error in your SQL syntax; check the manual that
corresponds ....
... near '; SET PASSWORD FOR 'LinqUser'@...

Each line succeeds, when executed individually.
Apologies if it's something trivial.
I am using a 'Script tab' in MySql query browser 1.1.20 (on windows).
Database version: 5.0.22-community-nt.

Any ideas?
Thanks for any advice,
George
Linq to Mysql project: http://code2code.net/Linq_Mysql/

Worked fine for me. Did you log in as Root when using QB.

QB 1.2.8.
MySQL 1.0.27

Thanks Jared.
I upgraded to Query Browser 1.2.8 and now it's working fine.
Cheers, George

Jared wrote: