MySQL 5.0 released

jouwnaam · Oct 25, 2005

http://dev.mysql.com/

MySQL 5.0 is the most ambitious release in MySQL's history. MySQL 5.0 delivers the enterprise features the community has been asking for, including Stored Procedures, Triggers, Views, Information Schema, XA Distributed Transactions, and new Storage Engines. We also added Strict SQL Mode to eliminate some of the ‘Gotchas’. Plus, MySQL 5.0 builds on our reputation for Reliability, Performance, and Ease of Use.

sullise · Oct 25, 2005

Is it backward compatible though?

jouwnaam · Oct 25, 2005

Not everything is compatible since 4.1

See the list at http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

Is it possible to upgrade to v5 from v4 or should I expect problems?

jmstacey · Oct 25, 2005

You'll need to read the upgrade documentation. It might or might not be an easy upgrade. The upgrade from 4.0 to 4.1 wasn't painless.

jouwnaam · Oct 26, 2005

Did the upgrade today using RPM's and mysql_fix_priveleges. So far no problems.

Remeber to use user = da_admin and the correct password for mysql_fix_priveleges.

Don't worry if you see a information_schema database. It's a new feature in version 5

Also, don't forget to rebuild PHP.

RPM's I needed:
MySQL-client-5.0.15-0.i386.rpm
MySQL-server-5.0.15-0.i386.rp,
MySQL-devel-5.0.15-0.i386.rpm
MySQL-shared-5.0.15-0.i386.rpm

hackerpitbull · Oct 26, 2005

jouwnaam said:
Did the upgrade today using RPM's and mysql_fix_priveleges. So far no problems.

Remeber to use user = da_admin and the correct password for mysql_fix_priveleges.

Don't worry if you see a information_schema database. It's a new feature in version 5

Also, don't forget to rebuild PHP.

RPM's I needed:
MySQL-client-5.0.15-0.i386.rpm
MySQL-server-5.0.15-0.i386.rp,
MySQL-devel-5.0.15-0.i386.rpm
MySQL-shared-5.0.15-0.i386.rpm

Do u know if MySQL 5.0 uses charsets like
/usr/share/mysql/charsets/*.xml

the only resaon that i dont upgrade is Hebrew support - updating 4.0-4.1 - all hebrew in databases mixed up.

jouwnaam · Oct 26, 2005

Just checked: hebrew.xml is dated 21-10-2005. I guess that is the release date of version 5.

hackerpitbull · Oct 26, 2005

jouwnaam said:
Just checked: hebrew.xml is dated 21-10-2005. I guess that is the release date of version 5.

thanks, i'll wait for another hosting company in IL to update mysql, why shuld i become the guinea pig

Titam · Oct 26, 2005

I just updated with this script :
At the question, what version, i put 5.0.15-0

I had an error message but, all is running at this time, phpmyadmin says me that mysql is in 5.0.15, DA too

Where could be other problem ?

Code:

#!/bin/sh

cd $HOME

echo -e "\n\n\033[1;37mMettre à jour vers quelle version? (ex : 4.1.14-0 )\033[0m"
read INSTALL_VER

echo -e "\n\n\033[1;37mMise à jour vers MySQL ${INSTALL_VER}\033[0m\n\n";

MYSQL_LINE=`echo ${INSTALL_VER} | cut -d. -f1,2`

wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-server-${INSTALL_VER}.i386.rpm
wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-client-${INSTALL_VER}.i386.rpm
wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-devel-${INSTALL_VER}.i386.rpm

rpm -Uvh ./MySQL-server-${INSTALL_VER}.i386.rpm ./MySQL-client-${INSTALL_VER}.i386.rpm ./MySQL-devel-${INSTALL_VER}.i386.rpm

rm -fr ./MySQL-server-${INSTALL_VER}.i386.rpm ./MySQL-client-${INSTALL_VER}.i386.rpm ./MySQL-devel-${INSTALL_VER}.i386.rpm

service mysql restart

echo -e "\n\n\033[1;37mMise à jour effectuée vers MySQL ${INSTALL_VER}\033[0m\n\n";

exit 0;
~

hackerpitbull · Oct 26, 2005

try:

Code:

#!/bin/sh

cd $HOME

echo -e "\n\n\033[1;37mMettre à jour vers quelle version? (ex : 5.0.15-0 )\033[0m"
read INSTALL_VER

echo -e "\n\n\033[1;37mMise à jour vers MySQL ${INSTALL_VER}\033[0m\n\n";

MYSQL_LINE=`echo ${INSTALL_VER} | cut -d. -f1,2`

wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-server-${INSTALL_VER}.i386.rpm
wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-client-${INSTALL_VER}.i386.rpm
wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-devel-${INSTALL_VER}.i386.rpm
wget [url]http://mir2.ovh.net/ftp.mysql.com/Downloads/MySQL-[/url]${MYSQL_LINE}/MySQL-shared-${INSTALL_VER}.i386.rpm

rpm -Uvh ./MySQL-server-${INSTALL_VER}.i386.rpm ./MySQL-client-${INSTALL_VER}.i386.rpm ./MySQL-devel-${INSTALL_VER}.i386.rpm ./MySQL-shared-${INSTALL_VER}.i386.rpm

rm -fr ./MySQL-server-${INSTALL_VER}.i386.rpm ./MySQL-client-${INSTALL_VER}.i386.rpm ./MySQL-devel-${INSTALL_VER}.i386.rpm ./MySQL-shared-${INSTALL_VER}.i386.rpm

service mysql restart

echo -e "\n\n\033[1;37mMise à jour effectuée vers MySQL ${INSTALL_VER}\033[0m\n\n";

exit 0;

jouwnaam · Oct 26, 2005

Where did you get an error message?

don't forget to run mysql_fix_priveleges and recompile php

Titam · Oct 26, 2005

Code:

./MySQL-server-5.0.15-0.i386.rpm: signature V3 DSA: NOKEY, key ID 5072e1f5
Préparation...              ########################################### [100%]
   1:MySQL-devel            ########################################### [ 33%]
   2:MySQL-server           ########################################### [ 67%]
051026 16:11:10 [Warning] Asked for 196608 thread stack, but got 126976
051026 16:11:10 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=serveur2-bin' to avoid this problem.
051026 16:11:10 [Warning] Asked for 196608 thread stack, but got 126976
051026 16:11:10 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=serveur2-bin' to avoid this problem.
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 serveur2.hollinae.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
[url]http://www.mysql.com[/url]
Support MySQL by buying support/licenses at [url]https://order.mysql.com[/url]
Starting MySQLCouldn't find MySQL manager or server[ÉCHOUÉ]
   3:MySQL-client           ########################################### [100%]
MySQL manager or server PID file could not be found!       [ÉCHOUÉ]
Starting MySQLCouldn't find MySQL manager or server        [ÉCHOUÉ]


Mise à jour effectuée vers MySQL 5.0.15-0


[root@serveur2 scripts]# service mysqld restart
Shutting down MySQL                                        [  OK  ]
Starting MySQL                                             [  OK  ]

But it's workink now in 5.0.15 without problem.

As I did an update and not an install, i have too do the fix privilege ? because i have no problem there (by fix privilege it's the script in /usr/local/directadmin/scripts/mysql_fix_privilege_tables ?)

jouwnaam · Oct 26, 2005

You really have to run /usr/bin/mysql_fix_privilege_tables

Titam · Oct 26, 2005

Code:

[root@serveur2 scripts]# /usr/bin/mysql_fix_privilege_tables --user=root ...
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, stored procedures, or
more secure passwords in 4.1

done
[root@serveur2 scripts]#

So it's done ^^

jouwnaam · Oct 26, 2005

well done

@how@ · Oct 26, 2005

how to update mysql with Redhat Enterprise 4.0

Code:

#!/bin/sh

service mysql stop

cd $HOME

echo -e "\n\n\033[1;37mUpgrade to what version? 5.0.15\033[0m"
read INSTALL_VER

echo -e "\n\n\033[1;37mUpgrading to MySQL 5.0.15\033[0m\n\n";

wget [url]http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-server-standard-5.0.15-0.rhel4.i386.rpm/from/http://mysql.mirrors.pair.com/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-client-standard-5.0.15-0.rhel4.i386.rpm/from/http://mysql.mirrors.pair.com/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-devel-standard-5.0.15-0.rhel4.i386.rpm/from/http://mirror.services.wisc.edu/mysql/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-standard-5.0.15-0.rhel4.i386.rpm/from/http://mysql.orst.edu/[/url]

rpm -Uvh ./MySQL-server-5.0.15-0.rhel4.i386.rpm ./MySQL-client-5.0.15-0.rhel4i386.rpm ./MySQL-devel-5.0.15-0.rhel4.i386.rpm ./MySQL-shared-5.0.15-0.rhel4.i386.rpm

rm -fr ./MySQL-server-5.0.15-0.rhel4.i386.rpm ./MySQL-client-5.0.15-0.rhel4.i386.rpm ./MySQL-devel-5.0.15-0.rhel4.i386.rpm ./MySQL-shared-5.0.15-0.rhel4.i386.rpm

service mysql restart

echo -e "\n\n\033[1;37mSuccessfully upgraded to MySQL 5.0.15\033[0m\n\n";
rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql

exit 0;

CrazyLane · Oct 27, 2005

MySQL 5 will break oscommerce and other carts based on oscommerce. joins and oscommerce are written incorrectly.

Joins are handled differently mysql5.

@how@ · Oct 31, 2005

done 100%

thanks,
Wael

@how@ · Nov 1, 2005

i need to go back for one server from 5.0.15 to 4.1.14

CrazyLane · Nov 1, 2005

I just reloaded the 4.1.14 rpms and recompiled php.

MySQL 5.0 released

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User