MySQL won't start

Ephracis · 12-24-2004, 08:05 PM

I have slackware 10.0 which I installed mysql on at the installation. I thought that I may start from scratch instead when it would not run (it ended just as I logged in every time) so I used pkgtool to remove it and got the source from mysql.com

Now I have done all steps in the readme-file and I tried to run mysqld_safe. I got the same thing here, it just ended.

Code:

root@garanka:/usr/local/mysql$ bin/mysqld_safe --user=mysql &
[1] 10681
Starting mysqld daemon with databases from /usr/local/mysql/data
041225 02:57:03  mysqld ended

So I used mysqld instead, got some errors and checked some thing. Here's the stuff:

Code:

root@garanka:/usr/local/mysql$ mysqld --user=mysql
041225  2:57:44  Warning: Asked for 196608 thread stack, but got 126976
041225  2:57:44  Can't start server : Bind on unix socket: No such file or directory
041225  2:57:44  Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ?
041225  2:57:44  Aborting

041225  2:57:44  mysqld: Shutdown complete

root@garanka:/usr/local/mysql$ ps aux | grep mysql
root     10715  0.0  0.0  1676  588 pts/2    S+   02:58   0:00 grep mysql
root@garanka:/usr/local/mysql$ ls -l /var/run/mysql/ 
ls: /var/run/mysql/: No such file or directory

I do not know what the first error about it getting some wrong number on the thread stack buton the third line it says something about running mysqld already, which I don't (I check with ps just in case). And also, the mysql.sock is not even in that place that the error shows, that place does not exist. I tried to make that directory but it gave the same error after that too.

So what to do now?

jacks4u · 12-26-2004, 03:54 AM

It seems to my that there is no database. Mysql keeps a database of such things as user names and host names, names of other databases it keeps, etc... In fact Mysql uses it's self to keep track of every thing.

You can create the initial database with mysqladmin. or perhaps the mysql user doesn't have access?

Here are some web references to help out:
http://dev.mysql.com/doc/mysql/en/index.html - a searchable on-lne doccumentation fpor mysql

http://dev.mysql.com/doc/mysql/en/My...istration.html - the administartion section of the same manual

enjoy
jacks4u

Ephracis · 12-27-2004, 06:04 AM

Yeah. Maby that was the problem. Anyway I solved it by installing mysql from source instead of binary. That did it. That's a reason I love installing from source.

Darin · 12-27-2004, 08:54 AM

In my install of Slackware I found references to how to get it to start when I went to track down the errors using some of these:

dmesg
/etc/rc.d/rc.mysqld
/var/log/*

...and someonewhere in there I found instructions on how to create the initial database that worked flawlessly.