Professional Web Applications Themes

problem CREATE USER - MySQL

Hi all, I'm new to mysql and I can't create a new user as: CREATE USER 'tester' IDENTIFIED BY 'mypasswd'; 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 'USER 'tester' IDENTIFIED BY 'mypasswd'' at line 1 Any help? Thanks, Marco...

  1. #1

    Default problem CREATE USER

    Hi all,
    I'm new to mysql and I can't create a new user as:

    CREATE USER 'tester' IDENTIFIED BY 'mypasswd';

    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 'USER 'tester' IDENTIFIED BY 'mypasswd'' at line 1

    Any help?
    Thanks,
    Marco

    Marco Guest

  2. #2

    Default Re: problem CREATE USER

    Marco Mussini wrote: 

    Are you positive this is *exactly* as you entered it? It works for me.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: problem CREATE USER


    "Marco Mussini" <it> wrote in message
    news:45602764$0$13763$news.tin.it... 

    Which version?

    <quote>
    The CREATE USER statement was added in MySQL 5.0.2
    </quote>


    Regards
    Dimitre



    Radoulov, Guest

  4. #4

    Default Re: problem CREATE USER

    This explains all... I'm using 4.1.14 version.
    Thanks,
    Marco


    Radoulov, Dimitre wrote:
     
    >
    > Which version?
    >
    > <quote>
    > The CREATE USER statement was added in MySQL 5.0.2
    > </quote>
    >
    >
    > Regards
    > Dimitre[/ref]

    Marco Guest

  5. #5

    Default Re: problem CREATE USER

    Marco Mussini wrote: 

    In 4.1.x, you don't need to use CREATE USER. Simply using GRANT to
    grant privileges to a user implicitly "creates" the user.

    Regards,
    Bill K.
    Bill Guest

Similar Threads

  1. Dynamic form to create pie chart - problem reprentingthe data not selected by user
    By sviolet in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: April 26th, 11:20 PM
  2. Create user in DB2
    By rupesh_nagar in forum IBM DB2
    Replies: 2
    Last Post: September 18th, 04:25 PM
  3. Create User
    By tman in forum SCO
    Replies: 2
    Last Post: September 9th, 09:56 PM

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