MySQL Forums
Forum List  »  Install & Repo

4.1-Schema won't assign, snaps back
Posted by: anders
Date: October 13, 2004 02:25PM

This is a 4.1 installation over a 4.0 installation. I created a db under 4.0, and it's working under 4.1. Queries, admin tool, query browser, all connect and run.

My problem is security and schema privileges. When I MySqlAdministrator->User Administration->click on root->click schema privileges tab, my settings for the schema don't "stick".

I can click on the << button, and all the privileges jump over to the "assigned" column. (I can also select them individually and use the < button.)

However, when I click the "apply changes" button, all the privileges "snap back" from the "assigned" column to the "available" column.

To get around this (and get everything else working, as mentioned above) I selected "disable grant tables". Obviously this isn't a long term solution. *grin*

A friend of mine noticed the same thing as he is in the middle of upgrading to 4.1 as well. Then I said "Aha! Two people makes a pattern!" (Well, that's a little bit of a stretch...) so I wondered if others had seen this, and (here's the kicker!) knew how to fix it.




Options: ReplyQuote

Written By
4.1-Schema won't assign, snaps back
October 13, 2004 02:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.