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]

rpm -q mysql" isn't going to help you, because you don't have a package named "mysql" installed. You have packages named "mysql-server", etc, installed. Try "mysql -qa | grep mysql" instead.





Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

after I typed "mysql -qa | grep mysql" it gives me this "mysql: unknown option '-a'

 

[Amei]

I just downloaded the 4.0 standard mysql-standard-4.0.20-pc-linux-i686.tar.gz and installed it, still having the socket problem. but this time what i type "rpm -g mysql" it shows "RPM version 4.3.1" then i started "/etc/init.d/mysql start" then "mysqladmin version" same error as before, want me to check to see if mysql.sock exists.

 

[Amei]

When I installed RedHat, I picked MySQL server and all the related programs.

Should I just go back to version 3.23? It was working.

But problem is I dont know how to go back, or how to uninstall it in Linux. I am a newbie.

 

[sleipnir214]

Sorry. Typo.

"mysql -qa | grep mysql"

Should have read:

"rpm -qa | grep mysql"



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

typed: "rpm -qa | grep mysql"
got: "mod_auth_mysql-20030510-4.1
php-mysql-4.3.4-11"

Should it automatically creat the mysql.sok when i start the server? Is this what you type to start the server"/etc/init.d/mysql start"?

If I can't fix this problem, how do I uninstall or go back to version 3.23?

Thank you for your quick reply!

 

[sleipnir214]

I'm concerned about the fact that no other MySQL packages are listed on your system.

Didn't you just install 3 MySQL 4.0.x packages?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[sleipnir214]

Sorry. Case-sensitivity is the problem.

If you do:

rpm -qa | grep -i mysql


what do you get?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

I know I install server, client, and one another one.

Typed: "rpm -qa | grep -i mysql"
Got: "perl-DBD-MySQL-2.9003-4
MySQL-shared-4.0.20-0
MySQL-server-4.0.20-0
mod_auth_mysql-20030510-4.1
MySQL-client-4.0.20-0
php-mysql-4.3.4-11"

Did I install too many of them? if so, what do I do next?

 

[sleipnir214]

You look good with your packages.

Now, from where did you get the MySQL-* packages?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

mysql.com download links. downloaded from Univercity of Wissconsin's FTP server.

 

[Amei]

Do I need to run the mysql_install_db script?
I am reading some other posts, trying to see if other people having same problem.

Did I do something wrong when I upgraded it?

In the mysqld.log file, it shows that when I run one of the updates, the client one i beleive, gives me a warning:
040625 14:11:08 Asked for 196608 thread stack, but got 126976
Fatal erros: Can't change to run as user 'mysql' ; Please check that the user exists!
040625 14:11:08 Aborting

040625 14:11:08 /usr/sbin/mysqlid: Shutdown Complete

 

[sleipnir214]

Did you go through the advice in the MySQL online manual section titled "Upgrading from Version 3.23 to 4.0"?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

Yes I did.

 

[sleipnir214]

Let's go back to the error you reported from the log.

Does the user "mysql" exist on your system?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

user mysql? don't think so. How do i check?

do i need to add group also?
"groupadd mysql"
"useradd -g mysql mysql"

 

[sleipnir214]

When you create the user, by default a group by the same name is also created.



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Amei]

When I fist installed RedHat, I didn't do anything other than "/etc/init.d/mysql start", and I didn't get any error message about the socket.

 

[Amei]

How do I check to see if I added user "mysql"?