Problems with MySQL on CentOS 4
 

I've been reading around all day about what to do, and I've not really got very far. I'm trying to get MySQL going but haven't succeded I tried updating and got this:

Setting up Update Process
Setting up repositories
update 100% |=========================| 951 B 00:00
base 100% |=========================| 1.1 kB 00:00
centosplus 100% |=========================| 951 B 00:00
addons 100% |=========================| 951 B 00:00
extras 100% |=========================| 1.1 kB 00:00
Reading repository metadata in from local files
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:5.0.58-1.el4.centos set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for
package: dovecot
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for
package: cyrus-sasl-sql
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for
package: php-mysql
--> Processing Dependency: libmysqlclient.so.15 for package: mysql
--> Processing Dependency: mysql = 4.1.20-3.RHEL4.1.el4_6.1 for
package: mysql-bench
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for
package: mysql
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for
package: freeradius-mysql
--> Processing Dependency: mysql-libs = 5.0.58-1.el4.centos for package: mysql
--> Processing Dependency: mysql-client for package: MySQL-test-community
--> Processing Dependency: libmysqlclient_r.so.14(libmysqlclient_14)
for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.14(libmysqlclient_14)
for package: MySQL-python
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for
package: mysql-server
--> Processing Dependency: mysql = 4.1.20-3.RHEL4.1.el4_6.1 for
package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package php-mysql.i386 0:5.1.6-3.el4s1.8 set to be updated
---> Package mysql-bench.i386 0:5.0.58-1.el4.centos set to be updated
---> Package mysql-server.i386 0:5.0.58-1.el4.centos set to be updated
---> Package mysql-libs.i386 0:5.0.58-1.el4.centos set to be updated
---> Package mysqlclient14.i386 0:4.1.22-1.el4s1.1 set to be updated
--> Running transaction check
--> Processing Dependency: mysql-client for package: MySQL-test-community
--> Processing Dependency: php-pdo for package: php-mysql
--> Processing Dependency: php-common = 5.1.6-3.el4s1.8 for package: php-mysql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package php-common.i386 0:5.1.6-3.el4s1.8 set to be updated
---> Package php-pdo.i386 0:5.1.6-3.el4s1.8 set to be updated
--> Running transaction check
--> Processing Dependency: mysql-client for package: MySQL-test-community
--> Finished Dependency Resolution
Error: Missing Dependency: mysql-client is needed by package
MySQL-test-community


Apologies if it's something glaringly obvious I'm new at this.
I have searched here and on Google but got no where.

Thankyou

What was the actual command you ran to try and update?

Clearly, MySQL-test-community needs mysql-client which, apparently, you do not have. Mysql-client is a GUI front-end. I don't know Centos but perhaps you should download and install mysql-client first. Normally, of course, it's not necessary because you can use MySQL quite happily on the command line.

Have a look here:-

http://rpm.pbone.net/index.php3/stat....i386.rpm.html

You'll see that mysql-client is a dependency and you can download it.

Hope this helps.

Richard

Thank you fro the help.

The original comand was yum --enablerepo=centosplus update mysql

Tried downloading the client it's not made any difference still getting the same message.

If you are getting exactly the same error message then it would appear that either the client hasn't been installed properly, or it has been installed to a place where mysql-test-community can't find it.

You could try running this from the command line:-

find / -iname '*mysql-client*'


Or this:-

pkg-config --list-all

...to see if pkgconfig knows about it.


For further help you could have a look here:-

http://dev.mysql.com/doc/refman/5.0/en/linux-rpm.html

Make sure that all the packages relate to the same version of MySQL. The above link deals with version 5, but later versions are listed on the side bar.

Richard