service mysqld start failed

[Miki]

Code: [Select]

Create database interface template (Forced)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


[MRatWork]

See /var/log/mysql.log.

[Miki]

140227 01:29:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140227  1:29:56 [Warning] option 'relay_log_space_limit': unsigned value 17179869184 adjusted to 4294967295
140227  1:29:56 [Note] Plugin 'FEDERATED' is disabled.
140227  1:29:56 InnoDB: The InnoDB memory heap is disabled
140227  1:29:56 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140227  1:29:56 InnoDB: Compressed tables use zlib 1.2.3
140227  1:29:56 InnoDB: Initializing buffer pool, size = 128.0M
140227  1:29:56 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
140227  1:29:56  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
140227  1:29:56  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
140227  1:29:56  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
140227  1:29:57  InnoDB: Waiting for the background threads to start
140227  1:29:58 InnoDB: 5.5.36 started; log sequence number 0
140227  1:29:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140227  1:29:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140227  1:29:58 [Note] Server socket created on IP: '0.0.0.0'.
140227  1:29:58 [Warning] 'user' entry 'root@server.domain.tld.com' ignored in --skip-name-resolve mode.
140227  1:29:58 [Warning] 'user' entry '@server.domain.tld.com' ignored in --skip-name-resolve mode.
140227  1:29:58 [Warning] 'proxies_priv' entry '@ root@server.domain.tld.com' ignored in --skip-name-resolve mode.
140227  1:29:58 [Note] Event Scheduler: Loaded 0 events
140227  1:29:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.36'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Distributed by The IUS Community Project
140227  2:04:58 [Warning] 'user' entry 'root@server.domain.tld.com' ignored in --skip-name-resolve mode.

[MRatWork]

I am not sure, but you can try 'sh /script/mysql-convert --engine=myisam' to change innodb to myisam.

[Miki]

sudah dicoba dan belum berhasil maupun cleanup fix-all reinstall mysql.. ada solusi lain?
service mysqld restart                                            Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
[root@nserver ~]# sh /script/mysql-convert --engine=myisam
Convert of MySQL engine
- Converting to myisam engine
[root@nserver ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
[root@nserver ~]# sh /script/mysql-convert --engine=innodb
Convert of MySQL engine
- Converting to innodb engine
[root@nserver ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

[MRatWork]

Coba tambahkan 'innodb_force_recovery = 2' dibawah '[mysqld]' pada /etc/my.cnf.

Jika tidak tidak berhasil naikkan nilai 2 ke 4.

[Miki]

  mantap master..
sukses..


Terima kasih banyak master..

[Miki]

mohon tuntunan untuk pengamanan serangan.. berikut ini ada jejak yang ditinggalkan pada folder temp berupa jpg bertuliskan hacker by .. foto terlampir dibawah ini: