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

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]