Can't start MySql server

[neilmurray]

I am using MySQL from a tarred file (mysql-4.1.9.tar.gz) on Mandrake Linux 9.2. I go through the installation as given in PHP & MySQL for dummies but when i get to the end and command /usr/local/mysql/bin/mysqld_safe &

I get this

# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/shockwave.pid
050118 15:04:38 mysqld ended


What's the problem?

Thanks,

Neil.

 

[Deleted]

Check the error messages in /usr/local/mysql/var/shockwave.err

http://unixjunky.com

 

[neilmurray]

Thanks,

I checked the error messages as you advised and found this.

050119 10:15:46 mysqld started
/usr/local/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/root/tmp/ibYp969G' (Errcode: 13)
050119 10:15:46 InnoDB: Error: unable to create temporary file; errno: 13
050119 10:15:46 [ERROR] Can't init databases
050119 10:15:46 [ERROR] Aborting

050119 10:15:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

050119 10:15:46 mysqld ended

I made sure I was su when trying to run and still got the same error.
To rectify this problem I tried changing the ownership of this to the local user, same error. I then changed the mod to 777, same problem.

Any ideas?

Neil.

 

[dalchri]

Try creating a text file in /root/tmp using the same user account and see if you have any trouble.

 

[neilmurray]

That was one problem, I kept changing ownership until I was able to write to the file. I have now rerun mysql and gotten another error

050119 14:02:50 mysqld started
050119 14:02:51 [ERROR] Can't start server : Bind on unix socket: Address already in use
050119 14:02:51 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
050119 14:02:51 [ERROR] Aborting

050119 14:02:51 [Note] /home/neil/mysql/libexec/mysqld: Shutdown complete

050119 14:02:51 mysqld ended


Do yo know how I can fix this?

Thanks,

Neil.

 

[dalchri]

Try ps -A and make certain that mysqld and mysqld-safe are present nowhere. Doing a top and then sorting by memory usage may be an easier way to see this.

If mysqld or mysqld_safe are present, do a kill -9 <pid> until they are gone or just restart your server.

 

[neilmurray]

definately mysqld nor mysqld_safe are not present.
Neil.

 

[dalchri]

Try

telnet <mysql server ip address> 3306

from another computer.

This may shed some light on whether another program is using port 3306.

You might also check for a leftover /tmp/mysql.sock file from a previous server crash and deleting it.

More info is here:

http://dev.mysql.com/doc/mysql/en/Starting_server.html

 

[neilmurray]

Fantastic.

There was a leftover /tmp/mys....sock file, I deleted it and all is working.

Thanks a lot. I appreciate it.

Neil.