Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
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:
Click Here
Please login or register. 2024-03-29, 07:59:58

Author Topic: [Mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '  (Read 4675 times)

0 Members and 1 Guest are viewing this topic.

Offline wildanisme

  • Junior Member
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
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.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
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'.
« Last Edit: 2019-06-27, 06:37:44 by MRatWork »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline wildanisme

  • Junior Member
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Harusnya server.cnf
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline wildanisme

  • Junior Member
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
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]

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Coba kembalikan dulu ke storage-engine awal yaitu myisam. Apakah pakai myisam juga tidak bisa jalankan mysql?
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline wildanisme

  • Junior Member
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
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]
-------------------------------------------------------------------

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Coba di reboot.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline wildanisme

  • Junior Member
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
tetap saja tidak bisa

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Coba disable 'socket=' menjadi '#socket='
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline wildanisme

  • Junior Member
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Mestinya 'default-storage-engine=' diisi 'myisam' atau 'aria'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.03 seconds with 18 queries.

web stats analysis