MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: wildanisme on 2019-06-26, 18:43:37

Title: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: wildanisme on 2019-06-26, 18:43:37
sebelumnya saya menjalankan perintah convert engine ke inno db
Quote
sh /script/mysql-convert --engine=innoDB
kemudian merestart semua service.
setelah restart, tidak bisa login control panel. Muncul pesan seperti ini
Quote
Warning: session_start(): Session data file is not created by your uid in /usr/local/lxlabs/kloxo/httpdocs/login/index.php on line 6
saya ketik mysql. Muncul pesan berikut
Quote
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
lalu saya reset password panelnya. sama saja tidak bisa.
menjalankan command
Quote
sh /script/fix-all
tdk bisa juga.
barangkali ada yg pernah senasib.
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: MRatWork on 2019-06-27, 06:26:52
Ini karena mysql tidak mau jalan. Coba lihat di '/etc/my.cnf' dan '/etc/my.cnf.d/server' apakah ada tulisan 'skip-innodb' (tanpa '#' didepannya). Jika ada, hilangkan tanda '#' di depan tulisan 'skip-innodb'.

Tambahkan 'socket=/var/lib/mysql/mysql.sock' dibawah '[mysqld]' pada '/etc/my.cnf.d/server.cnf

Lakukan restart dengan 'sh /script/restart-mysql'.
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: wildanisme on 2019-06-27, 14:06:10
Quote from: MRatWork on 2019-06-27, 06:26:52
Ini karena mysql tidak mau jalan. Coba lihat di '/etc/my.cnf' dan '/etc/my.cnf.d/server' apakah ada tulisan 'skip-innodb' (tanpa '#' didepannya). Jika ada, hilangkan tanda '#' di depan tulisan 'skip-innodb'.

Tambahkan 'socket=/var/lib/mysql/mysql.sock' dibawah '[mysqld]' pada '/etc/my.cnf.d/server.cnf

Lakukan restart dengan 'sh /script/restart-mysql'.

'etc/my.cnf.d/server' tdk ada mas
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: MRatWork on 2019-06-27, 14:25:50
Harusnya server.cnf
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: wildanisme on 2019-06-27, 15:56:37
Quote from: MRatWork on 2019-06-27, 14:25:50
Harusnya server.cnf

Tetap tdk bisa jalan. Muncul pesan seperti ini
Quote
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 260: kill: (2353) - No such process
                                                           [FAILED]
  - Process: restart
MariaDB server PID file could not be found!                [FAILED]
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: MRatWork on 2019-06-27, 17:03:32
Coba kembalikan dulu ke storage-engine awal yaitu myisam. Apakah pakai myisam juga tidak bisa jalankan mysql?
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: wildanisme on 2019-06-27, 19:42:16
Quote
sh /script/mysql-convert --engine=MyISAM
Convert of MySQL engine
/etc/init.d/mysql: line 260: kill: (10131) - No such process
/etc/init.d/mysql: line 260: kill: (10328) - No such process
- Converting to myisam engine

Restart MySql

Quote
*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190628 00:39:50 mysqld_safe Logging to '/var/lib/mysql/vsr.dmn.com.err'.
190628 00:39:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
../etc/init.d/mysql: line 260: kill: (10526) - No such process
                                                           [FAILED]
  - Process: restart
MariaDB server PID file could not be found!                [FAILED]
Starting MariaDB.190628 00:39:55 mysqld_safe Logging to '/var/lib/mysql/sr.dmn.com.err'.
190628 00:39:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
../etc/init.d/mysql: line 260: kill: (10723) - No such process
                                                           [FAILED]
-------------------------------------------------------------------
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: MRatWork on 2019-06-27, 19:57:59
Coba di reboot.
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: wildanisme on 2019-06-27, 20:50:51
tetap saja tidak bisa
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: MRatWork on 2019-06-27, 22:33:46
Coba disable 'socket=' menjadi '#socket='
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: wildanisme on 2019-06-28, 03:02:37
Quote
[mysqld]
#socket=/var/lib/mysql/mysql.sock
default-storage-engine=engine
skip-innodb
max-allowed-packet=256M
performance-schema=on
#OpenVZ AIO bug fix
innodb-use-native-aio=0


ini isi file server.cnf
Title: Re: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '
Post by: MRatWork on 2019-06-28, 03:29:37
Mestinya 'default-storage-engine=' diisi 'myisam' atau 'aria'.