Cannot get Mysql work on Redhat Enterprise 4

Hi experts,

I am running Rehdat enterprise 4 linux and Mysql MySQL-server5.0.19-0
i get the following with
# mysqladmin ping
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 when try to start the mysql server
# /etc/init.d/mysql restart
MySQL manager or server PID file could not be found!       [FAILED]
Starting MySQLCouldn't find MySQL manager or server        [FAILED]


it looks like mysql is not running on my server
# ps -ef | grep mysql
root      4177  3931  0 16:21 pts/1    00:00:00 grep mysql

/var/lib/mysql/mysql.sock actually does not exists on my system.

i would appreciate any help on this issue

thanks

cakirfatihAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

m1tk4Commented:
did you remove mysql 4 before installing 5.0.19?

What was your ./configure line when you were building it?
0
evangineerXCommented:
Yes, more info needed.  How did you install and configure Mysql?

You might find it useful to do "locate mysql.sock" to make sure it hasn't been created in a different location from what's in your my.cnf file.  

Also, have you looked at the my.cnf file at all and made sure that it has what you need?
0
cakirfatihAuthor Commented:
yes i did remove mysql 4 before installing 5.0.19
i used the rpm packages from the mysql website , so i did not have to use ./configure command.

i have installed these packages from the mysql website

           MySQL-client-standard 5.0.19-0.rhel3       
           MySQL-server-standard 5.0.19-0.rhel3       
           MySQL-shared-compat 5.0.19-0.rhel3
           MySQL-shared-standard 5.0.19-0.rhel3

after this i did not make any configurations because i cannot get it worked.

also here is the copy of my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock


[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

m1tk4Commented:
I would strongly suggest you to use

mysql-5.0.18-4.el4s1.1.i386

instead of MySQL's RPM. You can get this one from RHN, it's a part of  Red Hat Web Application Stack 1.0 Beta.

0
cakirfatihAuthor Commented:
how should i go with a clean uninstall of the current version of Mysql and then
install the version you mention.

i don't wana do it my way, which is using webmin.
is there any other you can recomend.

thanks
0
m1tk4Commented:
rpm -e MySQL-client-standard MySQL-server-standard MySQL-shared-compat MySQL-shared-standard

from the command line. This will leave behind some backups of my.cnf and maybe other files, when you run this command it'll tell you something like

my.cnf.backup saved as a backup...

delete all these files manually, then you should be good to go to install the new one. If you see any other output while you are removing the RPMs, post it here.
0
cakirfatihAuthor Commented:
i get this message

]# rpm -e MySQL-client-standard MySQL-server-standard MySQL-share d-compat MySQL-shared-standard
error: Failed dependencies:
        libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-21.RHEL4.1. i386
        libmysqlclient.so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-5.EL 4.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i3 86

i also have a subscription to redhat network for tech support, i could not find the mysql-5.0.18-4.el4s1.1.i386 there
how can i get this version?
i could not find it on rpmfinder website as well

thanks
0
m1tk4Commented:
ok, add those rpms to the list you are removing:

rpm -e MySQL......  MyODBC cyrus-sasl-sql dovecot

If you need them you can reinstall them later once you install the new MySQL.

To get it from RHN, log in into RHN, (rhn.redhat.com), click "Channels" in the red main menu bar, one of the channels listed is named:

 Red Hat Web Application Stack 1.0 Beta (for ES v. 4 x86)

Click that,  in the small menu where it says Details - Errata - Packages click Packages, they should be on the first page.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cakirfatihAuthor Commented:
that worked,
thanks for your help
0
m1tk4Commented:
you're welcome, thanks for the points ;)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.