I Can't start mysql
 

hi all

On my FC3 I was running mysql 3.23 and I wanted to upgrade to mysql 5.0 I downloaded the rpms from mysql.com and I did a rpm -Uvh MySQL*

This are the files that I installed:

MySQL-shared-5.0.19-0
MySQL-server-5.0.19-0
MySQL-bench-5.0.19-0
MySQL-client-5.0.19-0
MySQL-Max-5.0.19-0
MySQL-devel-5.0.19-0
MySQL-shared-compat-5.0.19-0

Everything went well, I was able to upgrade mysql but Im getting an error when i try to start mysql

Starting MySQLCouldn't find MySQL manager or server [FAILED]

Does anybody know what to do?

Thanks

Starting MySQLCouldn't find MySQL manager or server [FAILED]

You need to start the mysql server before you can start the client. Use this command: /usr/bin/mysqld_safe (on some distros it might be: /usr/bin/safe_mysqld) to start the server. Then try to start the client.

mmm that didn't work

this is the error message

chown: `mysql': invalid user
Starting mysqld-max daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060312 23:35:37 mysqld ended

Seems like you need to create a dedicated "mysql" user account (and group) first.
This is shown at http://dev.mysql.com/doc/refman/5.0/...ng-binary.html for
installing based on a tar-ball rather than an rpm.

However, the MySql docs suggest that, if the rpm installs properly, the server should be running after installation.
See: http://dev.mysql.com/doc/refman/5.0/en/linux-rpm.html

So my guess is that something went wrong with the upgrade.