[opencms-dev] Problem upgrading mySQL version 3.23

[maria.freixes_graells at alcatel.es]

Christian! Thanks for all!!

Thanks a lot, I think that now I've updated to 5.0 version.
I delete the previous versions of MySQL and I install as follow:
[root at ESBARD0E01404 mysql]# rpm -Uvh 
MySQL-server-standard-5.0.22-0.rhel3.i386.rpm
warning: MySQL-server-standard-5.0.22-0.rhel3.i386.rpm: V3 DSA 
signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### 
[100%]
   1:MySQL-server-standard  ########################################### 
[100%]
060627 12:17:10 [Warning] Neither --relay-log nor --relay-log-index were 
used; so replication may break when this MySQL server acts as a slave 
and has his hostname changed!! Please use 
'--relay-log=ESBARD0E01404-relay-bin' to avoid this problem.
060627 12:17:10 [Warning] Neither --relay-log nor --relay-log-index were 
used; so replication may break when this MySQL server acts as a slave 
and has his hostname changed!! Please use 
'--relay-log=ESBARD0E01404-relay-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 ESBARD0E01404 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 http://shop.mysql.com
Can't find program '/usr/bin/mysqlcheck'
Please restart with --basedir=mysql-install-directory
Starting MySQL[  OK  ]


[root at ESBARD0E01404 mysql]# rpm -Uvh 
MySQL-client-standard-5.0.22-0.rhel3.i386.rpm
warning: MySQL-client-standard-5.0.22-0.rhel3.i386.rpm: V3 DSA 
signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### 
[100%]
   1:MySQL-client-standard  ########################################### 
[100%]
[root at ESBARD0E01404 mysql]# rpm -Uvh 
MySQL-devel-standard-5.0.22-0.rhel3.i386.rpm
warning: MySQL-devel-standard-5.0.22-0.rhel3.i386.rpm: V3 DSA signature: 
NOKEY, key ID 5072e1f5
Preparing...                ########################################### 
[100%]
   1:MySQL-devel-standard   ########################################### 
[100%]
[root at ESBARD0E01404 mysql]# rpm -Uvh 
MySQL-shared-compat-5.0.22-0.rhel3.i386.rpm
warning: MySQL-shared-compat-5.0.22-0.rhel3.i386.rpm: V3 DSA signature: 
NOKEY, key ID 5072e1f5
Preparing...                ########################################### 
[100%]
   1:MySQL-shared-compat    ########################################### 
[100%]
[root at ESBARD0E01404 mysql]#
But I've an application that still says that it is using Client API 
version 3.23.58.
When I do:
[root at ESBARD0E01404 init.d]# mysql --version
mysql  Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i686) using readline 5.0
How can I be sure that I'm using the 5.0 version? Do you know something 
to test?

Thanks a LOT LOT!!!!

With the best wishes,
Maria