Professional Web Applications Themes

Error 1064 on 'SET PASSWORD' - MySQL

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/...

  1. #1

    Default Error 1064 on 'SET PASSWORD'

    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/

    gmoudry@gmail.com Guest

  2. #2

    Default Re: Error 1064 on 'SET PASSWORD'

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

    QB 1.2.8.
    MySQL 1.0.27


    Jared Guest

  3. #3

    Default Re: Error 1064 on 'SET PASSWORD'

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

    Jared wrote:
     

    gmoudry@gmail.com Guest

Similar Threads

  1. ERROR 1064 in mySQL 5.0.27
    By avidfan in forum MySQL
    Replies: 2
    Last Post: December 31st, 05:55 AM
  2. ERROR 1064 when trying to load dump from sql file
    By docw@globetrotter.net in forum MySQL
    Replies: 3
    Last Post: October 22nd, 09:56 PM
  3. Password Error
    By xlarrybearx in forum Macromedia ColdFusion
    Replies: 0
    Last Post: March 17th, 02:12 PM
  4. Password Error...
    By Steve Morley in forum Linux / Unix Administration
    Replies: 2
    Last Post: September 12th, 12:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139