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"