#1303 (in 2.6.0) Exporting mysql.user table

2.6.0-beta1
invalid
Marc Delisle
1
2013-06-11
2004-06-28
Donny Simonton
No

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.

Donny

Discussion

  • Marc Delisle
    Marc Delisle
    2004-06-28

    Logged In: YES
    user_id=210714

    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
     
  • 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
    user_id=210714

    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
    structure?
    And which MySQL version is this?

     
  • Logged In: YES
    user_id=418833

    Marc,

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

    MySQL 4.0.20 / 4.1.2 / 5.0.0

     
  • Marc Delisle
    Marc Delisle
    2004-06-29

    Logged In: YES
    user_id=210714

    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
    user_id=6296

    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
    user_id=210714

    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
     
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> invalid