Centos 5.5 - upgrade Mysql to 5.1 and get it working

I am not a server administrator but hope that one can help me. Thanks!

I have a fresh CentOS 5.5 with VirtualMin installed.

I get this when starting MySQL: Failed to start database : sh: /etc/rc.d/init.d/mysqld: No such file or directory

IN ADDITION, I wish to upgrade from 5.0 mysql to 5.1 mysql. I have already used this command:

rpm -Uvh MySQL-shared-community-5.1.56-1.rhel5.i386.rpm

But in Webmin my MySQL version still shows up as 开发者_StackOverflowmysql 5.0.77-4.el5_5.4, rather than upgrade 5.0 rpm just installs 5.1 along side it.

How do I upgrade to 5.1 and configure it to work? Thanks much.

If you already have mysql installed, try the "--replacepkgs" argument together with the "rpm" command.

Regarding sh: /etc/rc.d/init.d/mysqld: No such file or directory, it should be fixed once you install the newer mysql successfully.