MRatWork Forum by Mustafa Ramadhan - service mysqld start failed

Sponsor:
Server and Web Integrator
Link:
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:

MRatWork Forum | Please login or register. | 2017-11-07, 20:25:23

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- service mysqld start failed

« previous next »

- Print

Pages: [1] Go Down

### Author Topic: service mysqld start failed (Read 2415 times)

0 Members and 1 Guest are viewing this topic.

#### Miki

- Senior Member
- Posts: 167
- Karma: +0/-0

##### service mysqld start failed

« on: 2014-03-10, 16:24:49 »
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)

« Last Edit: 2014-03-10, 16:29:43 by Miki »
Logged
"the freedom speak is expression to exchange knowledge"

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: service mysqld start failed

« Reply #1 on: 2014-03-10, 16:29:04 »
See /var/log/mysql.log.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### Miki

- Senior Member
- Posts: 167
- Karma: +0/-0

##### Re: service mysqld start failed

« Reply #2 on: 2014-03-10, 16:35:03 »
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.
Logged
"the freedom speak is expression to exchange knowledge"

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: service mysqld start failed

« Reply #3 on: 2014-03-10, 16:41:32 »
I am not sure, but you can try 'sh /script/mysql-convert --engine=myisam' to change innodb to myisam.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### Miki

- Senior Member
- Posts: 167
- Karma: +0/-0

##### Re: service mysqld start failed

« Reply #4 on: 2014-03-10, 16:43:37 »
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]
« Last Edit: 2014-03-10, 16:46:19 by Miki »
Logged
"the freedom speak is expression to exchange knowledge"

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: service mysqld start failed

« Reply #5 on: 2014-03-10, 16:47:16 »
Coba tambahkan 'innodb_force_recovery = 2' dibawah '[mysqld]' pada /etc/my.cnf.
Jika tidak tidak berhasil naikkan nilai 2 ke 4.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### Miki

- Senior Member
- Posts: 167
- Karma: +0/-0

##### Re: service mysqld start failed

« Reply #6 on: 2014-03-10, 16:51:49 »
mantap master..
sukses..
Terima kasih banyak master..
Logged
"the freedom speak is expression to exchange knowledge"

#### Miki

- Senior Member
- Posts: 167
- Karma: +0/-0

##### Re: service mysqld start failed

« Reply #7 on: 2014-03-10, 16:54:06 »
mohon tuntunan untuk pengamanan serangan.. berikut ini ada jejak yang ditinggalkan pada folder temp berupa jpg bertuliskan hacker by .. foto terlampir dibawah ini:
Logged
"the freedom speak is expression to exchange knowledge"

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- service mysqld start failed

MRatWork Affiliates: BIGRAF(R) Inc. House of LMAR EFARgrafix

..:: Monetize Your Website with ylliXmedia ::.. ..:: Online Advertising that Sale Anything with ylliXmedia ::..

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.048 seconds with 17 queries.

Mirror created by MasterkinG32.CoM