MySQL socket problem

[Or!]

it is not really an osC issue, but I am sure there are enought profis in this field: I'm trying to install an MySQL-Server as non root in my home-derictory on the following box:

SunOS 5.9 Generic_118558-11 sun4u sparc SUNW,UltraAX-i2

 

I'm starting it like this:

./bin/mysqld -b ./ -P 49000

 

and that is what I get:

 

050909 10:59:46 [ERROR] Can't start server : Bind on unix socket: Address already in use

050909 10:59:46 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?

050909 10:59:46 [ERROR] Aborting

 

its clear, since there a couple of users like me with their own mysqld-processes, one of had taken the standard socket-file.

 

I have already managed once to start the server on this machine. I had the same problem but since a couple of month everything was OK, I forgot how I did it. The machine was restarted or upgraded (it is an web-server) and my background process was killed (as far as I understand what happened) since once when I tried to access my shop I get this:

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (146) in /***/***/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

I checked with telnet my old port number and nothing was there (I tried to check it with ps, but its syntax was obviosly changed so I get only process without their owners.)

 

I thougth that I should either 1) create my own socket in my home derictory (but I dont know how and couldn't find it) or 2) start server without using socket (but I aslo don't know how).

 

could someone help me?

 

thank you in advance...

[♥Vger]

You are correct - this is nothing to do with osCommerce. You would be better off using a MySQL forum. You'd be more likely to get the help you need on a forum which specialises in what you are trying to do.

 

Vger