Update problems - MySQL

[edamron]

I upgraded my SUSE 9.0 Linux server with MySQL 5.0.24a-max. Everything
seemed to go okay but when I try to access the user information with
mysql-administrator 1.2.3rc I now get the error "Could not retrieve
user information for '<insert user name here>' MySQL Error Nr. 1054
Unknown column 'Create_view_priv' in 'field list'

I have tried deleting a user and recreating the account and it seemed
like it worked until I closed mysql-administrator and reopened it.
After I that the same thing happened.

What do I need to do to straighten this out?

Thanks.

[Jerry]

edamron wrote: 

Maybe post the code you're using so we can see what's going on?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
net
==================

[Axel]

"edamron" <net> wrote:
 

I guess you had a pre-5.x MySQL on that box before? You kept your data?
 

Seems like your permission tables (the tables in the `mysql` database)
haven't been upgraded to 5.0. How *exactly* did you do the upgrade?
Did you run the mysql_upgrade script?

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

[edamron]

Jerry Stuckle wrote: 
>
> Maybe post the code you're using so we can see what's going on?
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> net
> ==================[/ref]

The error happens when I use mysql-administrator and click on an icon
for a user. (no code)

[edamron]

Axel Schwenke wrote: 
>
> I guess you had a pre-5.x MySQL on that box before? You kept your data?
> 
>
> Seems like your permission tables (the tables in the `mysql` database)
> haven't been upgraded to 5.0. How *exactly* did you do the upgrade?
> Did you run the mysql_upgrade script?
>
> http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
> http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html
>
>
> XL
> --
> Axel Schwenke, Senior Software Developer, MySQL AB
>
> Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
> MySQL User Forums: http://forums.mysql.com/[/ref]

That was it. I didn't know about the scripts. Thanks!

[Jerry]

edamron wrote: 
>>
>>Maybe post the code you're using so we can see what's going on?
>>
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>net
>>==================[/ref]
>
>
> The error happens when I use mysql-administrator and click on an icon
> for a user. (no code)
>[/ref]

Ok, I didn't read it right the first time.

Axel's got the right answer. You didn't update your user tables. See
the upgrade instructions for your release; you need to run a script to
do it.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
net
==================