mysql ERROR 2002 (HY000): hatası

17-04-2013, 23:13:59

#1

ridoerdie
Centos Yüklü Cloud sunucumda ssh ta

mysql komutu verdiğimde
```
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'y' (2)
```
Hatası alıyorum.

/etc/my.cnf

[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
17-04-2013, 23:22:21

#2

sysadmin
ridoerdie adlı üyeden alıntı: mesajı görüntüle
Centos Yüklü Cloud sunucumda ssh ta

mysql komutu verdiğimde

ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'y' (2)
Hatası alıyorum.

/etc/my.cnf

[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
```
ps -aux | grep mysqld
```
çıktısı nedir ?

17-04-2013, 23:26:21

sysadmin adlı üyeden alıntı: mesajı görüntüle

ps -aux | grep mysqld

çıktısı nedir ?

Çıktı bu şekilde

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
root      7069  0.0  0.0  63864  1236 pts/2    S    23:22   0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
mysql     7177  0.4  2.3 599496 96536 pts/2    Sl   23:22   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --log-error=/var/lib/mysql/mail.x.com.tr.err --pid-file=/var/lib/mysql/mail.x.com.tr.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root      7226  0.0  0.0  63864  1232 pts/2    S    23:23   0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
mysql     7339  0.2  2.0 540264 86104 pts/2    Sl   23:23   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --log-error=/var/lib/mysql/mail.x.com.tr.err --pid-file=/var/lib/mysql/mail.x.com.tr.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root      7509  0.0  0.0  61320   788 pts/2    S+   23:24   0:00 grep mysqld

17-04-2013, 23:44:10

sysadmin

ridoerdie adlı üyeden alıntı: mesajı görüntüle

Çıktı bu şekilde

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
root      7069  0.0  0.0  63864  1236 pts/2    S    23:22   0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
mysql     7177  0.4  2.3 599496 96536 pts/2    Sl   23:22   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --log-error=/var/lib/mysql/mail.x.com.tr.err --pid-file=/var/lib/mysql/mail.x.com.tr.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root      7226  0.0  0.0  63864  1232 pts/2    S    23:23   0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
mysql     7339  0.2  2.0 540264 86104 pts/2    Sl   23:23   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --log-error=/var/lib/mysql/mail.x.com.tr.err --pid-file=/var/lib/mysql/mail.x.com.tr.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root      7509  0.0  0.0  61320   788 pts/2    S+   23:24   0:00 grep mysqld

ls -lah /var/lib/mysql/mysql.sock

çıktısı nedir ?

17-04-2013, 23:46:09

#5

ridoerdie
sysadmin adlı üyeden alıntı: mesajı görüntüle
ls -lah /var/lib/mysql/mysql.sock
çıktısı nedir ?
çıktı bu şekilde
```
srwxrwxrwx 1 mysql mysql 0 Apr 17 23:24 /var/lib/mysql/mysql.sock
```
17-04-2013, 23:49:42

#6

Crazy

MySQL sunucu calisiyor mu?
service mysql status
ps aux | grep mysql

Diskinizde yeterli alan var mi?
df -h

MySQL'in calistigi port dinleniyor mu?
sudo netstat -pant | grep 3306
sudo netstat -pant | grep mysql

Bir çözüm daha, /var/run/mysqld/ Gerekli İzinlerini verin.
/var/run/mysqld/mysqld.sock
Belgesini silin sildikten sonra mysql'i başlatıp tekrar durdurduktan sonra,
/var/run/mysqld/mysqld.sock
belgesini geri yükleyin, fakat yedek almadan kesinlikle yapmayın.

Birde, /etc/mysql/my.cnf dosyasının içinde bind-address = 127.0.0.1 şeklinde bir satır olacak o satırı # işaretiyle etkisizleştirdikten sonra mysql'i tekrar çalıştırmayı dene

Bir çok çözümü mevcut,
http://forums.mysql.com/read.php?11,9689,9689#msg-9689

Umarım faydalı olur, kolay gelsin.
17-04-2013, 23:54:15

#7

sysadmin
ridoerdie adlı üyeden alıntı: mesajı görüntüle
çıktı bu şekilde

srwxrwxrwx 1 mysql mysql 0 Apr 17 23:24 /var/lib/mysql/mysql.sock
```
mysql --socket=/var/lib/mysql/mysql.sock -uroot
```
yaparak dener misin ?

Eğer hata verirse hatayı ve
```
cat /var/lib/mysql/mail.x.com.tr.err
```
çıktısını buraya yapıştırır mısın

18-04-2013, 00:01:17

ridoerdie

sysadmin adlı üyeden alıntı: mesajı görüntüle

mysql --socket=/var/lib/mysql/mysql.sock -uroot

yaparak dener misin ?

Eğer hata verirse hatayı ve

cat /var/lib/mysql/mail.x.com.tr.err

çıktısını buraya yapıştırır mısın

mysql --socket=/var/lib/mysql/mysql.sock -uroot

hata vermedi mysql e bağlandı

mysql --socket=/var/lib/mysql/mysql.sock -uroot

Çıktının bir kısmı

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
130417 23:25:39  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
130417 23:25:39  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
130417 23:25:40 [ERROR] Plugin 'InnoDB' init function returned error.
130417 23:25:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130417 23:25:55 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
130417 23:25:55 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130417 23:25:55 [ERROR] Aborting

130417 23:25:55 [Note] /usr/sbin/mysqld: Shutdown complete

130417 23:25:55 mysqld_safe mysqld from pid file /var/lib/mysql/mail.x.com.tr.pid ended
130417 23:26:20 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:26:45 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:27:41 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:28:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:28:39 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:29:06 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:29:35 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:30:03 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:30:32 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:31:00 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:31:56 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:32:53 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:33:21 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:34:46 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:35:14 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:35:42 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:35:49 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:36:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:36:40 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:37:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:37:38 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:37:47 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:38:04 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:38:37 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:40:02 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:40:57 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:41:23 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:41:49 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:41:51 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:42:54 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:43:15 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:44:12 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:45:41 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:46:37 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:47:06 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:47:33 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:48:04 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:49:00 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:50:27 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:51:25 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:51:53 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:52:23 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:53:49 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:54:46 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:55:16 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:55:47 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:56:13 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:56:43 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:57:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:58:09 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:58:39 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired

18-04-2013, 00:08:18

sysadmin

ridoerdie adlı üyeden alıntı: mesajı görüntüle

mysql --socket=/var/lib/mysql/mysql.sock -uroot

hata vermedi mysql e bağlandı

mysql --socket=/var/lib/mysql/mysql.sock -uroot

Çıktının bir kısmı

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
130417 23:25:39  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
130417 23:25:39  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
130417 23:25:40 [ERROR] Plugin 'InnoDB' init function returned error.
130417 23:25:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130417 23:25:55 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
130417 23:25:55 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130417 23:25:55 [ERROR] Aborting

130417 23:25:55 [Note] /usr/sbin/mysqld: Shutdown complete

130417 23:25:55 mysqld_safe mysqld from pid file /var/lib/mysql/mail.inkasoft.com.tr.pid ended
130417 23:26:20 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:26:45 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:27:41 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:28:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:28:39 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:29:06 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:29:35 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:30:03 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:30:32 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:31:00 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:31:56 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:32:53 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:33:21 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:34:46 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:35:14 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:35:42 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:35:49 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:36:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:36:40 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:37:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:37:38 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:37:47 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:38:04 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:38:37 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:40:02 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:40:57 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:41:23 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:41:49 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:41:51 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:42:54 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:43:15 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:44:12 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:45:41 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:46:37 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:47:06 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:47:33 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:48:04 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:49:00 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:50:27 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:51:25 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:51:53 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:52:23 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:53:49 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:54:46 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:55:16 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:55:47 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:56:13 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:56:43 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:57:11 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:58:09 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired
130417 23:58:39 [ERROR] /usr/sbin/mysqld: Table './tribunvi_tvideo/wp_redirection_logs' is marked as crashed and should be repaired

Tamam sende bağlanmak istiyordun sanırım yalnız şuan da mysql'in şifresiz olarak çalışıyor. Özellikle böyle çalışmasını sen mi istedin ?

pkill -9 mysqld
rm -f /etc/my.cnf
service mysqld restart

yaptıktan sonra tekrar bağlanmayı deneyebilirsin tabi eğer /root/.my.cnf dosyanda mysql root şifren yazmıyorsa şifre belirterek bağlanabilirsin.

Ardından

tribunvi_tvideo database'ini repair edebilirsin.