Re: Help with error while storing the user information mysql administrator - Michael G. Zinner - com.mysql.lists.gui-tools

7 messages in com.mysql.lists.gui-toolsRe: Help with error while storing the...

From	Sent On	Attachments
Joey	06 Jan 2005 15:54
Michael G. Zinner	06 Jan 2005 16:23
Joey	06 Jan 2005 16:30
Alfredo Kengi Kojima	06 Jan 2005 18:13
Joey	06 Jan 2005 18:53
Joey	07 Jan 2005 00:24
Michael G. Zinner	07 Jan 2005 04:23

Subject:	Re: Help with error while storing the user information mysql administrator
From:	Michael G. Zinner (mzin...@mysql.com)
Date:	01/07/2005 04:23:32 AM
List:	com.mysql.lists.gui-tools

Joey,

the issue has now been fixed in the MySQL Administrator. It will be in the next release which will be out later today.

Mike

Joey wrote:

OK it did the table creation while still providing the error. I changed the user_info with alter table user_info convert to character set utf8; as well as the user table.

I reload mysql, close the administrator, and go into mysql administrator and same thing can't create a new user, with the same error...

-----Original Message----- From: Alfredo Kengi Kojima [mailto:alfr...@mysql.com] Sent: Thursday, January 06, 2005 9:14 PM To: Joey Cc: gui-...@lists.mysql.com Subject: RE: Help with error while storing the user information mysql administrator

The table should be autocreated when you try to save changes to a user again.

In case the save fails again and the user_info table again is created with the latin1 charset, try the following command from the command line client:

alter table user_info convert to character set utf8;

and then retry saving changes. Please report your results, as it might be a bug.

-- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina

Are you MySQL certified? www.mysql.com/certification

On Thu, 6 Jan 2005, Joey wrote:

The table was not auto created per say, and so I no longer have the user_info table. Is there a setting for my.cnf I should use to insure the proper coding is done? Also FYI this is RPM's I downloaded right from mysql, another box with similar problem is Fedora Core3 out of the box so to speak. Can you send me a dump of the structures you have so I can try to rebuild it?

Thanks

-----Original Message----- From: Michael G. Zinner [mailto:mzin...@mysql.com] Sent: Thursday, January 06, 2005 7:59 PM To: Victor Vagin Cc: Joey Subject: Re: Help with error while storing the user information mysql administrator

VVA,

can you please check this user's problem? Why is the user_info table not created as UTF8?

Joey, could you drop this table by executing the following SQL statement from phpMyAdmin or MySQL Query Browser?

DROP TABLE mysql.user_info;

Then restart MySQL Administrator which will re-create the table. If it is still not in UTF8, this is a major issue.

Btw. you can see the Character Set + Collation in MySQL Administrator. Go to the Catalog section and select the mysql schema. Then double click on the user_info table. On the 2nd page of the Table Editor you can see the information.

Thanks, Mike

Joey wrote:

The user_info table was set to Latin1_swedish_ci setting via an option that said Collation, I changed it to utf8_bin, reloaded mysql and still the same error occurs. I see this info via phpMyadmin. Several of the tables have this same setting including user.

Any ideas?

Thanks!

-----Original Message----- From: Michael G. Zinner [mailto:mzin...@mysql.com] Sent: Thursday, January 06, 2005 7:24 PM To: Joey Cc: gui-...@lists.mysql.com; Victor Vagin Subject: Re: Help with error while storing the user information mysql administrator

Hi,

could you check the character set of the test.user_info table? It should be UTF8. If it is latin1se this might cause troubles.

Joey wrote:

I am running MySQL Administrator ver 1.018 on a Windows XP Pro system. On the server I have MySQL Server ver 4.18 on Fedora Core3. When I add a user via the management it shows me "error while storing the user information". This is simply adding a user name and their password.

The funny thing is the user gets added to the DB. When I try to ad privaleges to the user I get the same error, and in this case the settings don't get saved.

Any ideas?

Thanks!!!

Are you MySQL certified? www.mysql.com/certification

http://lists.mysql.com/gui-tools?unsub=alfr...@mysql.com

Are you MySQL certified? www.mysql.com/certification