mysql error

[Silent1]

Just finished installing debian and i just compiled and installed mysql 4.0. When i try to start it i get this error,
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Now i can't find mysql.sock on my system, find / -name mysql.sock returns nothing. Any ideas? Thanks in advance.

[Stupendous]

It sounds like the server isn't running.

How are you starting the server? It sounds like you are using 'mysql'.

The binary 'mysql' is for connecting to an active server.

[Silent1]

yeah thats exactly what i'm doing, mysql start How should i start it?

[Stupendous]

mysqld is what you want to run. Do you want this running all the time or just whenever you start it?

I'm not sure exactly what you need to do to get it to start up when your Debian machine boots up.

To run it from the console you would issue the command 'mysqld --console'. Then to stop it just do Ctrl-C.

[Silent1]

i got alittle further but now i'm stuck again :) And now i'm getting this error,

./mysqld start
040201 14:28:05 InnoDB: Started
040201 14:28:05 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040201 14:28:05 Aborting

040201 14:28:05 InnoDB: Starting shutdown...
040201 14:28:08 InnoDB: Shutdown completed
040201 14:28:08 ./mysqld: Shutdown Complete

[Stupendous]

Who are you running this as?

[Silent1]

mysql

[Silent1]

got it up and running, the db dir need a permission change :)