Re: can't start server

[aman raheja]

Do check the ownership on /var/lib/mysql
if not right, then
chown -R mysql /var/lib/mysql
I am getting out of ideas here. Would recommend to uninstall all the 
mysql packages - mysql-server, mysql-client and other you have installed 
and start afresh.

Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:

Hello again

I installed mysql from rpm.
I did check the status of the server with ps -ef | grep mysqld
and indicated athat the demoen is not running.
I tried to start the server by
/etc/init.d/mysqld start and the error 2002
appeared again
In my.cnf file I have
[mysqld]
socket=/tmp/mysqld.sock
basedir=/var/lib/mysql/mysql
datadir=/var/lib/mysql
[client]
socket=/tmp/mysqld.sock


-----Original Message-----
From: aman raheja [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 2:27 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: can't start server
Do try ps -ef | grep mysqld
to check the server is currently running.
If not then do
/etc/init.d/mysqld start
Let know if there's an error at this point. Also show your my.cnf

Did you use rpm or source to install mysql?

Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:

 

Thank you again for your help.

I installed the 4.0 version of Mysql on a red hat 8.0 OS.
I am trying to use the database to create a forum (with PHP) for
discussion
It is a production server but with no critical status
I was able to start Mysql a couple months ago but somehow it went down
and since then I am
constantly getting the error message of : error 2002: can not connect
to server through socket /var/lib/mysql/mysql.sock
when I try to start it.
I am not expert but I can do some things around the server if I am
pointed to the right direction.
Thanks

[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

   -----Original Message-----
   From: aman raheja [mailto:[EMAIL PROTECTED]
   Sent: Wednesday, November 19, 2003 12:28 PM
   To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
   Subject: Re: can't start server
   Is this a production server?
   THIS IS not a good advice but If not then just step down to a
   lower init level turning off the network services and then come
   back into level 3/5 whatever you are using, depending on platform.
   Then try to start the server. If you would tell what platform you
   are running on and what version of mysql you are using, will help
   you get the solution faster - not the restarting the services kind :)
   Aman Raheja
   AGF Technologies
   http://www.agftech.com
   [EMAIL PROTECTED] wrote:

   

Aman, thank you for your reply.

I did check the ports with netstat and it appears that no other
application is using port 3306.
I am tempting to uninstall mysql and then reinstall it again but
I do not know how to uninstall it the easy way.
Thanks again

[EMAIL PROTECTED]

-----Original Message-----
From: aman raheja [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 9:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: can't start server
did you try netstat and see if something else is using the port.

Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:
     

I am sure that this problem has already been answered but some how I
       

can't
 

figure it out.

When I try to start the mysqld I get the error 2002 can't start server:

       

Bind
     

or TCP/IP port: Address already in use or...

I check that the damoen is not runnig (ps -ef |grep mysqld ) and shows
nothing running. But I just can start it.
Someone there can help me with easy step to fix this?

Thanks