Re: Help with error while storing the user information mysql administrator

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:[email protected]] 
> Sent: Thursday, January 06, 2005 9:14 PM
> To: Joey
> Cc: [email protected]
> Subject: RE: Help with error while storing the user information mysql
> administrator
> 
> 
> Hi
> 
> 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:[email protected]]
>>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:[email protected]]
>>>Sent: Thursday, January 06, 2005 7:24 PM
>>>To: Joey
>>>Cc: [email protected]; 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.
>>>
>>>
>>>Thanks,
>>>Mike
>>>
>>>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!!!
>>>>
>>>>
>>>
>>>
>>--
>>Michael Zinner, GUI Developer
>>MySQL AB, www.mysql.com
>>Office: +43 676 753 26 30
>>
>>Are you MySQL certified?  www.mysql.com/certification
>>
>>
>>
>>--
>>MySQL GUI Tools Mailing List
>>For list archives: http://lists.mysql.com/gui-tools
>>To unsubscribe:
> 
> http://lists.mysql.com/[email protected]
> 
> 
> 
> 

-- 
Michael Zinner, GUI Developer
MySQL AB, www.mysql.com
Office: +43 676 753 26 30

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

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]