Professional Web Applications Themes

Anonymous accounts on Windows. Where are they? - MySQL

First: I'm a newbie with MySQL. I downloaded the MYSQL Essentials, version 5.0.24a and installed on my Windows XP machine. I'm reading the manual at section 2.10.3. Securing the Initial MySQL Accounts, and it says: "Two anonymous-user accounts are created, each with an empty username." However, when I check the mysql.user table, I only find the "root" user. So I wonder: is the manual in error, or are the anonymous user accounts hidden somehow? That is, can I be sure to get ALL accounts when I look in mysql.user? Gustaf...

  1. #1

    Default Anonymous accounts on Windows. Where are they?

    First: I'm a newbie with MySQL. I downloaded the MYSQL Essentials,
    version 5.0.24a and installed on my Windows XP machine. I'm reading the
    manual at section 2.10.3. Securing the Initial MySQL Accounts, and it says:

    "Two anonymous-user accounts are created, each with an empty username."

    However, when I check the mysql.user table, I only find the "root" user.
    So I wonder: is the manual in error, or are the anonymous user
    accounts hidden somehow? That is, can I be sure to get ALL accounts when
    I look in mysql.user?

    Gustaf
    Gustaf Guest

  2. #2

    Default Re: Anonymous accounts on Windows. Where are they?

    Gustaf wrote: 

    This doentation doesn't seem to take into account the "instance
    configuration wizard" which is run by the installer on Windows. You can
    also run this instance configuration wizard at any time:
    "Start->Programs->MySQL->MySQL Server 5.0->MySQL Server Instance
    Configuration Wizard"

    Creation of the anonymous account is an optional step in the
    configuration of MySQL. In the last screen in the instance
    configuration wizard, you are prompted for the MySQL root password, and
    also prompted to mark a checkbox to create the anonymous accounts. The
    checkbox is not marked by default, so unless you checked it, it
    shouldn't have created the anonymous accounts.

    I just verified this by running the instance config wizard, marking the
    checkbox for the anonymous accounts, and letting it finish the config.
    Then I queried from the mysql.user table again, and it had two
    additional rows, with blank strings in the `user` column.

    Regards,
    Bill K.
    Bill Guest

  3. #3

    Default Re: Anonymous accounts on Windows. Where are they?

    Bill Karwin wrote:
     [/ref]
     

    Many thanks. Nice research. :-)

    Gustaf
    Gustaf Guest

Similar Threads

  1. A question about windows accounts
    By Chris Leffer in forum ASP.NET Security
    Replies: 1
    Last Post: November 12th, 01:52 PM
  2. ueser accounts on windows xp
    By Liz in forum ASP.NET Security
    Replies: 0
    Last Post: October 24th, 11:07 AM
  3. Replies: 2
    Last Post: August 31st, 07:32 AM
  4. Windows Authentication and Anonymous login URGENT
    By Michal A. Valasek in forum ASP.NET Security
    Replies: 3
    Last Post: August 6th, 07:31 PM
  5. Replies: 0
    Last Post: July 30th, 04:37 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