Hi,
> I have a problem connecting to the mysql server. I installed a new
> server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some
> websites running on it using the mysql server. Last friday I had a
> crash of one off my other servers and I copied the websites and db's
> to this new s
[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.
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 doe
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 ever
Glenn,
Thursday, May 23, 2002, 1:11:25 AM, you wrote:
GH> I have had trouble with the script that creates my user access tables.
GH> I am assuming those tables should get created in the ./var/mysql folder.
They are created in the MySQL data dir. So, if you data dir is
/var/mysql they will be cr
