Update problems

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.

edamron wrote:
> 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.
>

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.
jstucklex@attglobal.net
==================

"edamron" <edamron@spamcop.net> wrote:

> I upgraded my SUSE 9.0 Linux server with MySQL 5.0.24a-max.

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

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

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/...-from-4-1.html
http://dev.mysql.com/doc/refman/5.0/...l-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/

Jerry Stuckle wrote:
> edamron wrote:
> > 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.
> >
>
> 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.
> jstucklex@attglobal.net
> ==================

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

Axel Schwenke wrote:
> "edamron" <edamron@spamcop.net> wrote:
>
> > I upgraded my SUSE 9.0 Linux server with MySQL 5.0.24a-max.
>
> I guess you had a pre-5.x MySQL on that box before? You kept your data?
>
> > 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'
>
> 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/...-from-4-1.html
> http://dev.mysql.com/doc/refman/5.0/...l-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/

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

edamron wrote:
> Jerry Stuckle wrote:
>
>>edamron wrote:
>>
>>>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.
>>>
>>
>>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.
>>jstucklex@attglobal.net
>>==================
>
>
> The error happens when I use mysql-administrator and click on an icon
> for a user. (no code)
>

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.
jstucklex@attglobal.net
==================