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

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