#1303 (in 2.6.0) Exporting mysql.user table


In the past, when you exported the mysql.user table
you would see all of the information that you were
exporting. Now I see it's in new format that doesn't
allow you to read it and determine which ones that you
want to copy.

I assume this was added to High ASCII character sets,
but is there any way of adding a flag that allows us to
see the old version?

Most people take their permissions from one server, but
go through the list and determine which ones need to
actually be on a new server. We do this everytime we
copy the user data from one server to another.

The current system just doesn't make sense, since
MySQL itself doesn't even return the data in that format.



  • Marc Delisle

    Marc Delisle - 2004-06-28

    Logged In: YES

    Which new format? I just tried an export with default options
    and I cannot see your problem. Please show us an example
    (replace sensitive information by xxx).

  • Marc Delisle

    Marc Delisle - 2004-06-28
    • assigned_to: nobody --> lem9
  • Nobody/Anonymous

    Logged In: NO

    For example:

    INSERT INTO `user` VALUES (0x25, 0x4d72????????,
    0x2a453643353????????, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
    'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', '', '', '', '', 0, 0, 0);

    This is what I get when I go to the structure of the
    mysql.user table, then hit export at the top and choose
    export via SQL.

    I replaced most of the information with question marks.

  • Marc Delisle

    Marc Delisle - 2004-06-28

    Logged In: YES

    Clicking on "extended inserts" gives you only one INSERT
    command, I guess you do not want that.
    About the 0x..., I guess that your structure has those
    fields in binary. Can I see the export of user's table
    And which MySQL version is this?

  • Alexander M. Turek

    Logged In: YES


    The VARCHAR and TEXT fields of my user tables are BINARY by

    MySQL 4.0.20 / 4.1.2 / 5.0.0

  • Marc Delisle

    Marc Delisle - 2004-06-29

    Logged In: YES

    I sent a message on the -devel list but since it does not
    seem to be posted...
    BINARY does not mean that the contents is binary, according
    to MySQL doc. So should we add a user option to control the
    use of hexadecimal format for binary?

  • Donny Simonton

    Donny Simonton - 2004-06-29

    Logged In: YES

    I would definitely give the option in my opinion. It will
    definitely confuse a lot of people just as it did myself, since if
    you browser the table itself. PHPMyadmin returns the
    information in a readable format. But once you export it, you
    get hexadecimal format which is not very easy to read.

    I would just give the option, do you want this is hexidecimal
    format or regular format.

  • Marc Delisle

    Marc Delisle - 2004-07-01

    Logged In: YES

    New option added.

  • Marc Delisle

    Marc Delisle - 2004-07-01
    • priority: 5 --> 1
    • summary: Exporting mysql.user table --> (in 2.6.0) Exporting mysql.user table
    • status: open --> open-fixed
  • Alexander M. Turek

    • status: open-fixed --> closed-fixed
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> invalid

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks