Topic: MySQL 4.1.11

[edb]

Has anyone completed a successful upgrade to MySQL version 4.1.X on SME 6.0.1?
If so please direct me to the rpms. Thanks

Ed

[edb]

I found the rpms and upgraded to 4.1.11 fine.
I'm using Navicat to access the databases and now I get a "bad handshake" message when trying to access from the local network.

Used to work fine with 4.0.22.

I also get an error when I try to do /usr/bin/mysql_fix_privilege_tables

Error =

[root@mail root]# /usr/bin/mysql_fix_privilege_tables
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
[root@mail root]#

[gregswallow]

Code: [Select]

MYSQL_PW=sed q /etc/openldap/ldap.pw
/usr/bin/mysql_fix_privilege_tables --password=$MYSQL_PW

Searcha  bit harder, you'll find that others have done it before.

[edb]

Thank you Greg, I can very seldom seem to find what I'm lookin for with the search on contribs.org but that did the trick.

Thanks again

[NickBell]

Good fix
Couldn't find it elsewhere
Cheers

[lajgaard]

How much notice should I take of the following two errors in the instalation process of the rpm's.

050613  9:25:04 [Warning] Asked for 196608 thread stack, but got 126976
050613  9:25:11 [Warning] Asked for 196608 thread stack, but got 126976

I am trying to install:
MySQL-shared-compat-4.1.11-0.i386.rpm
MySQL-client-4.1.11-0.i386.rpm
MySQL-server-4.1.11-0.i386.rpm
MySQL-devel-4.1.11-0.i386.rpm

/Carsten

[NickBell]

050613 9:25:04 [Warning] Asked for 196608 thread stack, but got 126976

I get these errors all the time. Apparently if you increase ULIMIT somewhere you allocate MySQL more memory  and the (run-time and install-time) errors won't happen. MySQL seems to work fine with them though.

Computers are probably stuffed with unseen errors in logs, if if ain't broke don't try to fix it...

Nick