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-28, 09:38:14

Author Topic: Mysql can't start and getting failed  (Read 12795 times)

0 Members and 3 Guests are viewing this topic.

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #15 on: 2019-09-04, 17:54:56 »
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
After that seems everything is ok!  ;D
Thanks a lot!!

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #16 on: 2019-09-04, 18:05:12 »
... but after restart ... I have again to restart manually mysql with: sh /script/restart-mysql
  :( :( :-[

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #17 on: 2019-09-04, 19:00:29 »
inform here 'chkconfig --list|grep -i mysql|grep -v grep' and 'systemctl list-unit-files|grep mysql'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #18 on: 2019-09-04, 19:12:38 »
 chkconfig --list|grep -i mysql|grep -v grep

Note: This output shows SysV services only and does not include native
      systemd services. SysV configuration data might be overridden by native
      systemd configuration.

      If you want to list systemd services use 'systemctl list-unit-files'.
      To see services enabled on particular target use
      'systemctl list-dependencies [target]'.

mysql             0:off   1:off   2:on   3:on   4:on   5:on   6:off

systemctl list-unit-files|grep mysql
shows no output
« Last Edit: 2019-09-04, 19:20:03 by dfreddie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #19 on: 2019-09-04, 19:21:40 »
inform here 'pgrep mysql -a' and 'ps aux|grep -i mysql|grep -v grep'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #20 on: 2019-09-04, 19:27:04 »
pgrep mysql -a
4301 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
4380 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid


ps aux|grep -i mysql|grep -v grep
root      4301  0.0  0.0  11816  1604 pts/0    S    19:02   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
mysql     4380  0.3  1.5 1288988 188228 pts/0  Sl   19:02   0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #21 on: 2019-09-04, 19:31:29 »
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #22 on: 2019-09-04, 19:35:54 »
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
Yes becouse I've started it with "sh /script/restart-mysql" command after server booted.

With fresh restart:
pgrep mysql -a - no output
ps aux|grep -i mysql|grep -v grep - no output
« Last Edit: 2019-09-04, 19:41:51 by dfreddie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #23 on: 2019-09-04, 19:41:55 »
Try reboot and then check with 'pgrep' a couple of times.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #24 on: 2019-09-04, 19:46:32 »
Try reboot and then check with 'pgrep' a couple of times.
It starts delayed!
But my webpages shows Error 500 - Internal Server Error!
« Last Edit: 2019-09-04, 19:48:16 by dfreddie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #25 on: 2019-09-04, 19:54:21 »
inform here 'cat /etc/my.cnf.d/server.cnf'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #26 on: 2019-09-04, 19:56:41 »
cat /etc/my.cnf.d/server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
performance-schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
innodb-use-native-aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #27 on: 2019-09-04, 20:01:40 »
Try add:
Code: [Select]
socket=/var/lib/mysql/mysql.sock
bind-address=127.0.0.1
under '[mysqld]'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #28 on: 2019-09-04, 20:28:33 »
I've added but is the same. Mysql starts delayed and that for (I think) web server have to be restart for avoiding error 500.


 


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

Page created in 0.074 seconds with 23 queries.

web stats analysis