can't start mysqld

[ereo]

hello
today i've got trouble with mysql, i can't login because trouble with mysql, the browser give me notification

mysqld is stopped

Trying to start mysql server, please reload browser!

Could not connect: No such file or directory

how to fix it?

[erm3nda]

You didn't supply ANY info about your server details nor log info, so it's difficult to help you.

If mysql do not work, this may be a problem from installation. Is this the first time?

You can try restart whole cwp service by command `service cwpsrv restart` or only mysql by command `service mysql restart` or `/etc/init.d/mysqld restart`.

If not, try to reinstall mysql server using command `yum reinstall mysql-server`.

[ereo]

after checking with tail,

tail -n 30 /var/log/mysqld.log

it tell's me

141006 12:54:47 mysqld_safe mysqld restarted
141006 12:54:47 mysqld_safe Number of processes running now: 0
141006 12:54:47 mysqld_safe mysqld restarted
141006 12:54:47  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:47  InnoDB: Completed initialization of buffer pool
141006 12:54:48  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:48  InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
141006 12:54:48  InnoDB: Retrying to lock the first data file
141006 12:54:48  InnoDB: Started; log sequence number 0 103960
141006 12:54:48 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left on device
141006 12:54:48 mysqld_safe Number of processes running now: 1
141006 12:54:48 mysqld_safe mysqld process hanging, pid 23371 - killed
141006 12:54:48 mysqld_safe mysqld restarted
141006 12:54:48 mysqld_safe Number of processes running now: 0
141006 12:54:48 mysqld_safe mysqld restarted
141006 12:54:48  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:48  InnoDB: Completed initialization of buffer pool
141006 12:54:48  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:48  InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
141006 12:54:48  InnoDB: Retrying to lock the first data file
141006 12:54:48  InnoDB: Started; log sequence number 0 103960
141006 12:54:48 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left

[ereo]

solved after removing some folders and file, thanks for the help 

[erm3nda]

Glad to know i forced you to use logs 

141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left

[MarceloMG]

solved after removing some folders and file, thanks for the help 

Hi, which folders you remove? I have the same problem...

[chatig89]

solved after removing some folders and file, thanks for the help 

Can you tell me which folders you remove? same problem

[LiXuS]

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_hosting-lv_root
                       50G   47G     0 100% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sda2             477M  198M  255M  44% /boot
/dev/sda1             200M  268K  200M   1% /boot/efi
/dev/mapper/vg_hosting-lv_home
                      864G   37G  784G   5% /home


wich folder or file can i del?

[Administrator]

probably the best for start would be to check server logs in /var/log and /usr/local/apache/logs

[locvfx]

solved after removing some folders and file, thanks for the help 

Can you tell me which folders you remove? same problem

I guess you ran out of disk space
You can delete all unused log files or root's email. It happened to me after few months of using

du --max-depth=1 -h /   : List folder size
find / -type f -size +100M   : Find files with the size above 100MB
ls -1 -sh   : list folder and file
du -msh Folder_Name   : Get size of a  folder