Hi
I'm too embarrassed to post this question on the mySQL forums, mainly because I'm sure it's more of an issue with me not knowing what I'm doing rather than mySQL directly
I'm trying to install mySQL so I can learn it from both a server and client perspective, of course I'm in an endless loop here since I can't even get as far as installing it properly...
I have CentOS 4.4 installed on my home machine. The default mySQL client is installed:
[root@server install]# rpm -qa | grep -i mysql
mysql-4.1.20-1.RHEL4.1
Now, I want to install the server software, which I just downloaded from mySQL, along with the latest 4.x client software.
So I want to upgrade to the latest 4.x client, and then install the server software, etc..
I downloaded the following:
-rw-r--r-- 1 root root 5091213 Nov 23 08:13 MySQL-client-standard-4.1.22-0.rhel4.i386.rpm
-rw-r--r-- 1 root root 4941326 Nov 23 08:14 MySQL-devel-standard-4.1.22-0.rhel4.i386.rpm
-rw-r--r-- 1 root root 12376323 Nov 23 08:17 MySQL-server-standard-4.1.22-0.rhel4.i386.rpm
-rw-r--r-- 1 root root 1670773 Nov 23 08:18 MySQL-shared-compat-4.1.22-0.rhel4.i386.rpm
-rw-r--r-- 1 root root 1192119 Nov 23 08:18 MySQL-shared-standard-4.1.22-0.rhel4.i386.rpm
-rw-r--r-- 1 root root 15398642 Nov 23 08:18 MySQL-standard-debuginfo-4.1.22-0.rhel4.i386.rpm
-rw-r--r-- 1 root root 2046152 Nov 23 08:19 MySQL-test-standard-4.1.22-0.rhel4.i386.rpm
I tried to install the server software first, but getting failed dependencies left and right, so I tried upgrading the client version first and here is what I get:
[root@server install]# rpm -Uvh MySQL-client-standard-4.1.22-0.rhel4.i386.rpm
warning: MySQL-client-standard-4.1.22-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
file /usr/bin/mysql from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysql_waitpid from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysqladmin from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysqlbinlog from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysqlcheck from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysqldump from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysqlimport from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysqlshow from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/man/man1/mysql.1.gz from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.20-1. RHEL4.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1 .20-1.RHEL4.1
file /usr/share/man/man1/mysqladmin.1.gz from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1. 20-1.RHEL4.1
file /usr/share/man/man1/mysqldump.1.gz from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.2 0-1.RHEL4.1
file /usr/share/man/man1/mysqlshow.1.gz from install of MySQL-client-standard-4.1.22-0.rhel4 conflicts with file from package mysql-4.1.2 0-1.RHEL4.1
[root@server install]# rpm -qa | grep -i mysql
mysql-4.1.20-1.RHEL4.1
It's my understanding that rpm -Uvh is the proper RPM command to use to upgrade.
So next idea was to just uninstall the older version, since I haven't used mySQL yet anyway, but that doesn't work either:
[root@server install]# rpm -ev mysql-4.1.20-1.RHEL4.1
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
[root@server install]#
Where do I find libmysqlclient.so or what should I be doing to get this working?
Any advice would be much appreciated.
Thanks
Nat