Professional Web Applications Themes

Update problems - MySQL

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

  1. #1

    Default 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 Guest

  2. #2

    Default Re: Update problems

    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
    ==================
    Jerry Guest

  3. #3

    Default Re: Update problems

    "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/
    Axel Guest

  4. #4

    Default Re: Update problems


    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 Guest

  5. #5

    Default Re: Update problems


    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 Guest

  6. #6

    Default Re: Update problems

    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
    ==================
    Jerry Guest

Similar Threads

  1. Flash 9 update problems
    By Dgepley in forum Macromedia Flash Player
    Replies: 0
    Last Post: May 25th, 03:21 AM
  2. Template update problems
    By tshad in forum Dreamweaver AppDev
    Replies: 15
    Last Post: May 11th, 07:03 PM
  3. problems update 11.02 with XP
    By perpiomx in forum Macromedia Freehand
    Replies: 0
    Last Post: May 19th, 08:03 PM
  4. Freehand 10/MX problems, need update
    By Scott L. webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 6
    Last Post: February 18th, 09:21 AM
  5. 7.01 update problems
    By Todd Pratt in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 1
    Last Post: August 26th, 12:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139