Give your comments on Upgrading MySQL to 4.0.x for SME Server here. Thanks in advance!
I just wasted a day trying to get MySQL to work on the network, gave up, UPGRADED to 4.0 and seem to have fixed the problems!
Follow the instructions , there is one bug,
rpm -e --nodeps mysql
seems to be needed!
Apart from that, great
thx
mike
PS just did an upgrade on a clean SME6.0.1 machine, did not need the rpm -e mysql, however in step 1, I had to stop mysqld, (note the 'd') , mysql was not found!
I gave it a try: worked like a charm. I did not use "rpm -e --nodeps mysql" neither.
I even tried MySQL-Max :
# rpm -Uhv MySQL-Max-4.0.18-0.i386.rpm Preparing... ########################################### 100% 1:MySQL-Max ########################################### 100% Restarting mysqld. error: execution of %post scriptlet from MySQL-Max-4.0.18-0 failed, exit status 127 <<------ ?? is it a problem ? ## service mysqld restart Killing mysqld with pid 27293
plog99
I've discovered that there is on more thing to be done once upgraded to MySQL 4.0.X. It is covered in this link.
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
Quote: After upgrading, update the grant tables to add new privileges and features. The procedure uses the script mysql_fix_privilege_tables and is described in section
Doug M. "Rigger"