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

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]