mysql 4.0.24 and mysql4.1.10a released

the following assumes you have the official MySQL rpms installed (i.e. 4.0.23)

cd /usr/src/redhat/RPMS/i386

Grab MySQL Server Rpm
Code: 
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-server-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/[/url]

Grab the MySQL Client Rpm

Code: 
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-client-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/[/url]

Grab the MySQL Libraries/headers Rpm

Code: 
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-devel-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/[/url]

Grab the MySQL dynamic libs (shared) Rpm

Code: 
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-shared-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/[/url]

*note i gave you direct links from a MySQL mirrors page (normally this is bad, and you should check your hash), from http://dev.mysql.com/downloads/mysql/4.0.html

now to install them. The following assumes that those are the only MySQL rpms you downloaded to this directory.

Code: 
rpm -Uvh MySQL*

this automatically restarts mysql but it's also safe after to run

Code: 
service mysqld restart

and then test a few sites that use mysql and make sure everything is running smooth and you are done.
 
Hi

For some reason I couldn't do a 'direct' wget (was very slow) so I downloaded the files to my computer then ftp'd them to the server and did a wget from there.

I used cuteftp to upload the rpms, but I don't think they were uploaded in ascii (as its not in the ascii list) is that ok?

on installation i got the errors below. Should I re-install?


warning: MySQL-client-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-shared ########################################### [ 25%]
2:MySQL-client ########################################### [ 50%]
3:MySQL-devel ########################################### [ 75%]
4:MySQL-server ########################################### [100%]
Installing all prepared tables
050323 20:02:24 Warning: Asked for 196608 thread stack, but got 126976
050323 20:02:24 /usr/sbin/mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mydomainname.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
 
p.s I don't think its worked because I have restarted the box but it phpmyinfo it still says:

Client API version 4.0.17

:-/
 
I tried it again but this time it says:

warning: MySQL-client-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
package MySQL-shared-4.0.24-0 is already installed
package MySQL-client-4.0.24-0 is already installed
package MySQL-devel-4.0.24-0 is already installed
package MySQL-server-4.0.24-0 is already installed
:-(
 
client API version will be the version compiled into php, so if you update mysql and leave php be then it will still show the same version. A easy way to check is to login to phpmyadmin and see at the top what version is running eg. mine says.

MySQL 4.0.24-log running on localhost as xxxxxxxx@localhost
 
Yup it says:

MySQL 4.0.24-standard running on localhost as my_test@localhost

Does this mean I have to do anything to php tho (ie is it using the new or old version?) Or is it just the version 'name' that is compiled into the phpinfo?
 
Newbee said:
p.s I don't think its worked because I have restarted the box but it phpmyinfo it still says:

Client API version 4.0.17

:-/
Click to expand...

It's normal, you don't have compile PHP to use external client of MySQL.
Just modify configure.php for do this.
 
tribal-dolphin said:
It's normal, you don't have compile PHP to use external client of MySQL.
Just modify configure.php for do this.
Click to expand...

and how could i do that? can you describe?
 
Very simple, take a look to PHP configuration help
(./configure -- help ine the PHP source directory)

You see that :
--with-mysql => For the included client
--with-mysql=[DIR] => For an external client.

In my case (RH9 box with official Mysql 4.1.10a RPM) the value is :
--with-mysql=/usr/lib/

Just modifiy the line in configure.php and do a ./build -n php

That's all folk :)
 
Client API version => 3.23.49

thats what I got from a box using built in mysql client.

4.0.18 is using your mysql 4.0.18 client.
 
You must log in or register to reply here.
Back
Top