Upgrade socket problem

[Amei]

I just upgraded from 3.23 to 4.0. Downloaded mysql-server-4.0.20-0.i386, MySQL-shared-4.0.20-0.i386.rpm and MySQL-client-4.0.20-0.i386.rpm. then I did:
rpm -Uvh MySQL-server-4.0.20-0.i386.rpm
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
rpm -Uvh MySQL-client-4.0.20-0.i386.rpm
then i manually killed the mysql process and did shell> /etc/init.d/mysql start
When I do shell> mysqladmin version gives me an error message: mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
and I checked, in init.d directory, mysql exists, but not mysqld. and the mysql.sock doesn't exist either in mysql directory.
But when I type shell> mysqlshow --help it tells me that Ver 9.4 Distrib 4.0.20, for pc-linux (i686) and when i check if i have the package installed, i did: shell> rpm -q mysql, it says: package mysql is not installed.

I am running RedHat Fedora Core 2. The 3.23 version of mysql comes with it.

Please help!

 

[sleipnir214]

The RedHat RPM probably used some other username -- maybe "nobody".

To see if the "mysql" user exists on your system, examine the file /etc/passwd


You are also going to want to make sure that the "mysql" user and group are the owners of the MySQL datastore directory and that the permissions on the directory is 660. The directory, I believe, will be /var/mysql



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

In /etc/passwd
nobody:x:99:99:Nobody:/:/:sbin/nologin
ANOTHER LINE:
postgres:x:26:26ostgreSQL Server:/var/lib/pgsql:/bin/bash


the directory "mysql" is under /var/lib/mysql
How do i check the permissions on the directory if it's 660 or not?

 

[sleipnir214]

Create the user "mysql".

To check ownership and permissions, do "ls -l /var/lib/mysql"



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

woohoo... it's working now.

The problem was that it was looking for socket mysql.sok, but when I started the server, it created a socket called mysqld.sok. I had to manually modify the my.cnf file.

Thank you sleipnir214 for all the help, I couldn't do it without all that.

another thing I did was force reinstalled every package.