Trying to upgrade mysql as per eva2000's advise

[hydn]

I notice that although vb accesses mysql via password ok that on the windows server when i try to use the mysql command it dosn't take the password:
http://www.pinstack.com/images/mysql.gif

Question: Can I upgrade mysql if the password isn't working for the windows mysql install wizard?

[eva2000]

i get 404 with http://www.pinstack.com/images/mysql.gif ?

[hydn]

Site was down. Please try again

[eva2000]

you can upgrade mysql and then reset the password as well

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html

http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

http://dev.mysql.com/doc/refman/5.0/en/password-too-long.html

[hydn]

Got both Mysql and PHP upgraded.

My php.ini has never been updated.

Here's the server specs:
http://www.vbulletin.com/forum/showthread.php?t=187187

any php.ini suggestions?

[eva2000]

only increase memory_limit from default 8M to 16M at least

[hydn]

thanks everything working GREAT now!

[eva2000]

Good to hear :)

[hydn]

Are there any performance gains with a mysql upgrade to 5.0.27?

Currently have 4.1.22 installed.

THanks

[mlx]

Are there any performance gains with a mysql upgrade to 5.0.27?

Currently have 4.1.22 installed.

I'm not sure if you will notice any performance difference.

However MySQL 4.1 isn't actively supported anymore (http://www.mysql.com/company/legal/lifecycle/). So upgrading sooner or later would be a good idea anyway I guess.