Page 1 of 1
Mysql starting problem
Posted: Wed Mar 29, 2006 2:55 pm
by Cheeseboy
Hi when i do this command:
I get this error:
[1] 27643
Code: Select all
bash-3.00# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/tablesalt.pid
060329 15:53:07 mysqld ended
Does anyone know how i can fix this? Thx

Posted: Wed Mar 29, 2006 3:58 pm
by josh
I get this error:
[1] 27643
thats not an error, thats the PID for mysql
Posted: Wed Mar 29, 2006 4:14 pm
by Cheeseboy
ok the mysql server is running but now when i try to log in like this:
I get this error:
Code: Select all
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Also, /tmp/mysql.sock doesnt exist. So how can i log in?

THis is what i found in my error log:
060329 19:34:26 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created!
Posted: Wed Mar 29, 2006 7:09 pm
by RobertGonzalez
Make sure your my.cnf is setup and placed in the /etc/ folder. I had this same problem with a MySQL server update and needed to create the my.cnf before mysql would start again.
You can read up on what I did (and what I did about your socket problem)
right here.
Posted: Thu Mar 30, 2006 5:57 am
by Cheeseboy
Ok i checked my error log and this is what it says:
mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created!
Please help me. (*goes crazy*)

Posted: Thu Mar 30, 2006 1:47 pm
by Cheeseboy
ok, all i need now when i do the command:
How can i get it to stop saying:
Code: Select all
STOPPING server from pid file /usr/local/mysql/var/tablesalt.pid
060330 14:44:28 mysqld ended
Does anybody know how i can fix this?
Posted: Thu Mar 30, 2006 4:54 pm
by RobertGonzalez
First recommendation. Reboot the machine (if you can). Then try to login to mysql using the standard login command
See if that works.
Posted: Thu Mar 30, 2006 6:21 pm
by Cheeseboy
Nope i get the socket error again. How can i (install) the socket?
Posted: Fri Mar 31, 2006 10:17 am
by RobertGonzalez
OK, next thing to try. Inside of the /etc/my.cnf file, in the [mysqld] section, add the line
Restart the server (reboot the machine). See if that does anything. From the problem I was having with the socket issue, it appeared to be caused by one of three things...
- The server was already running when the admin tried to start it
- The my.cnf had not been created
- The server had not been stopped before installation/upgrade and caused a corruption.
There is a lot of talk about this problem at the MySQL forums. You might want to try there as well. Another to try is to google the entire error message. I found a lot of resources when I was searching.
Posted: Fri Mar 31, 2006 6:52 pm
by Cheeseboy
so i add this at the end of the page?
no # ?
Do you happen to know where i should put this:?
Code: Select all
To start mysqld at boot time you have to copy support-files/mysql.server
This could be the reason right here.
Posted: Fri Mar 31, 2006 7:43 pm
by RobertGonzalez
If you can't start mysql at the prompt I am not sure you'd be able to at boot. The skip-innodb command goes under the [mysqld] heading in your my.cnf file.
Posted: Fri Mar 31, 2006 8:10 pm
by Cheeseboy
ahh

, still have that socket problem do you think i should install it using a rpm? Also how can i kill the server i think its running.
Posted: Fri Mar 31, 2006 9:10 pm
by RobertGonzalez
Honestly, at this point I would be inclined to uninstall MySQL and reinstall it. I like the RPMs, but I am a Linux newbie who really doesn't know beter.
Posted: Sat Apr 01, 2006 1:45 pm
by Cheeseboy
ha, ive done that 3 times and (no charm)
