Upgraded MySQL 4.0 to 4.1
- Published January 16th, 2006 in Tips & Tricks, MySQL
Today I upgraded MySQL on one of my machines. The version currently installed was 4.0 and it was working fine (for what I expect MySQL to do, it did great and fast). I was wondering about trying all the new features of 5.0 (like triggers, for instance) but that was too risky for a production machine. So I decided to stick with version 4.1.
Everything went quite fine. Actually, it was a matter of apt-get install mysql-server4.1. Note that MySQL disables remote access by default, so remember to comment my.cnf in case you want it to be active (which should be if you have any remote client accessing to it!).
*for mysql < 4.1 (i think so) find the parameter skip-networking and comment it (#skip-networking)
*for mysql > 4.1 (i think so) find the parameter bind-address and comment it (#bind-adress)
Otherwise it won’t work as expected. Tip found here.
No Responses to “Upgraded MySQL 4.0 to 4.1”