2.5.4 Upgrading from Version 3.21 to 3.22

Nothing that affects compatibility has changed between versions 3.21 and 3.22. The only pitfall is that new tables that are created with DATE type columns will use the new way to store the date. You can't access these new columns from an old version of mysqld.

After installing MySQL Version 3.22, you should start the new server and then run the mysql_fix_privilege_tables script. This will add the new privileges that you need to use the GRANT command. If you forget this, you will get Access denied when you try to use ALTER TABLE, CREATE INDEX, or DROP INDEX. If your MySQL root user requires a password, you should give this as an argument to mysql_fix_privilege_tables.

The C API interface to mysql_real_connect() has changed. If you have an old client program that calls this function, you must place a 0 for the new db argument (or recode the client to send the db element for faster connections). You must also call mysql_init() before calling mysql_real_connect(). This change was done to allow the new mysql_options() function to save options in the MYSQL handler structure.

The mysqld variable key_buffer has been renamed to key_buffer_size, but you can still use the old name in your startup files.

User Comments

PLz... i now this is a VERY STUPID and innocent question...

i Don't know how to run a script :(
i am upgrading from 3.23 to 4.0.12 @ Windows platform

I ve installed the 4.0.12 version, and all seems to be alright, but it tells me (and also in the web site) that i should tun the
mysql_fix_privilege_tables
script...
i 've located the file in mysql dir, but... my problem is i dont know how to run a script :/ :(
PLZ s1 hel me .. ,:(

PS: is it a SQL query? a PHP command? :(
my mail if anyone could help me :
<a href="mailto:mfpinhal@netcabo.pt">mfpinhal@netcabo.pt<\a>
mfpinhal@netcabo.pt
Tnhx anyway :)

Add your own comment.