LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   mysql failed to start (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-failed-to-start-657606/)

nawuza 07-23-2008 01:41 AM

mysql failed to start
 
hello...mysql cannot start.in the log error says:
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibuheYgy' (Errcode: 28)
080724 4:32:00 InnoDB: Error: unable to create temporary file; errno: 28
080724 4:32:00 [ERROR] Can't start server : Bind on unix socket: No space left on device
080724 4:32:00 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
080724 4:32:00 [ERROR] Aborting

080724 4:32:00 [Note] /usr/libexec/mysqld: Shutdown complete

080724 04:32:00 mysqld ended

John VV 07-23-2008 02:10 AM

Quote:

/usr/libexec/mysqld: Can't create/write to file '/tmp/ibuheYgy
the answer is there mysql can not write to /tmp
it dose not have the right permissions
did you create a new user called mysql at time of install ?
and is /tmp/ibuheYgy file owned by mysql
see
http://dev.mysql.com/doc/refman/4.1/en/index.html
---------------------------
also it may have been running already
Quote:

080724 4:32:00 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?

nawuza 07-23-2008 02:32 AM

never mind..i reinstall my mysql.huhu

estabroo 07-23-2008 11:03 AM

The answer was here:

080724 4:32:00 [ERROR] Can't start server : Bind on unix socket: No space left on device

whatever disk/ram partition your /tmp was on was full

trickykid 07-23-2008 11:13 AM

Quote:

Originally Posted by estabroo (Post 3223846)
The answer was here:

080724 4:32:00 [ERROR] Can't start server : Bind on unix socket: No space left on device

whatever disk/ram partition your /tmp was on was full

Which means the reinstall is most likely to fail as well unless the OP clears out some space. Linux and it's applications are not like Windows. Reinstalls are always last options.


All times are GMT -5. The time now is 04:13 AM.