Thanks for responding. Preliminary tests indicate no problems, although it does of
necessity make assumptions about which of the new privileges existing users should
have when upgrading, but they were fairly safe.
> I would assume that you can since mysql probably does an internal
> select col, col1 to get the grant information and the new tables
> contain everything that the old ones do plus some extra privileges.
> The only thing I would worry about would be passwords changing. Make a
> small test case and let everybody know. :)
> On Fri, 3 Sep 2004 09:43:28 -0700 (GMT-07:00), zeus@stripped
> <zeus@stripped> wrote:
> > Hi there,
> > I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question
> is this: after I run the script to upgrade the grant tables to support the new
> privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust the
> grant tables. Thanks in advance.
> > -Bob
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> Eric Bergen