Re: grant tables update backward compatibility

2004-09-06 Thread Egor Egorov
[EMAIL PROTECTED] wrote: 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.

Re: grant tables update backward compatibility

2004-09-04 Thread Bob Hockney
Hi Eric,: 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. Regards, -Bob I would assume that you can since mysql probably

grant tables update backward compatibility

2004-09-03 Thread zeus
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.

Re: grant tables update backward compatibility

2004-09-03 Thread Eric Bergen
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