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
==================
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....
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:
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
==================
"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/
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)
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!
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
==================
Bookmarks