MySql 4.0 upgrade

[A. Lanza]

After installing FC2 i realized that the mysql server version installed
was 3.x. I wanted to install version 4.0, so i got the rpm
package from mysql website and i installed it on my system.

Now it seems like mysql server is not running. I get no output for the
command "ps -A | grep mysql". Also, when i try to connect to mysql
server using mysql client, i get the following error message:

ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

It seems like mysql server does not automatically start when i boot up
my computer... how can i start it manually? Where in the filesystem does
mysql server get installed after installing the rpm?

Though, when i run the Gnome Service config. utility, i can see mysql
service on the list, with a checkmark, and it appears to be running...
i'm so confused about this.

Please help.

Thanks in advance.