#1303 (in 2.6.0) Exporting mysql.user table

[Donny Simonton]

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

[Marc Delisle]

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

[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]

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?

[Alexander M. Turek]

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]

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]

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]

Logged In: YES
user_id=210714

New option added.