Hi,
I have a weird scenario, my sites are running fine but when I try to manage databases I get this:
“MySQL is not running on your system - database list could not be retrieved”
I also get this:
“/usr/bin/mysqlshow: Can’t connect to local MySQL server through socket ‘var/run/mysqld/mysqld.sock’ (2)”
I noticed mysql service is stopped when I go to system information. If I try to start it through Virtualmin, the page refresh but nothing happens…
do you know what it may be?
Here’s my extract of ps -A. I see a process for mysqld, so it’s weird Virtualmin doesn’t show it’s started though…
PID TTY TIME CMD
1 ? 00:02:01 init
2 ? 00:00:00 kthreadd
3 ? 00:00:00 ksoftirqd/0
4 ? 00:00:00 kworker/0:0
5 ? 00:00:00 kworker/u:0
6 ? 00:00:00 migration/0
7 ? 00:00:00 watchdog/0
8 ? 00:00:00 cpuset
9 ? 00:00:00 khelper
10 ? 00:00:00 kdevtmpfs
11 ? 00:00:00 netns
12 ? 00:00:00 sync_supers
13 ? 00:00:00 bdi-default
14 ? 00:00:00 kintegrityd
15 ? 00:00:00 kblockd
16 ? 00:00:00 ata_sff
17 ? 00:00:00 khubd
18 ? 00:00:00 md
19 ? 00:00:00 kworker/0:1
20 ? 00:00:00 kworker/u:1
21 ? 00:00:00 khungtaskd
22 ? 00:00:00 kswapd0
23 ? 00:00:00 ksmd
24 ? 00:00:00 khugepaged
25 ? 00:00:00 fsnotify_mark
26 ? 00:00:00 ecryptfs-kthrea
27 ? 00:00:00 crypto
35 ? 00:00:00 kthrotld
36 ? 00:00:00 scsi_eh_0
37 ? 00:00:00 scsi_eh_1
38 ? 00:00:00 kworker/u:2
57 ? 00:00:00 devfreq_wq
192 ? 00:00:00 jbd2/vda1-8
193 ? 00:00:00 ext4-dio-unwrit
224 ? 00:00:00 mountall
274 ? 00:00:00 upstart-udev-br
276 ? 00:00:00 udevd
400 ? 00:00:00 vballoon
403 ? 00:00:00 kpsmoused
411 ? 00:00:00 kworker/0:2
446 ? 00:00:00 udevd
475 ? 00:00:00 dhclient3
478 ? 00:00:00 udevd
547 ? 00:00:00 upstart-socket-
652 ? 00:00:00 kjournald
687 ? 00:00:00 sshd
690 ? 00:00:00 dbus-daemon
703 ? 00:00:00 rsyslogd
809 tty4 00:00:00 getty
816 tty5 00:00:00 getty
824 tty2 00:00:00 getty
826 tty3 00:00:00 getty
834 tty6 00:00:00 getty
850 ? 00:00:00 dovecot
851 ? 00:00:00 acpid
853 ? 00:00:00 cron
854 ? 00:00:00 atd
855 ? 00:00:00 named
868 ? 00:00:00 mysqld
876 ? 00:00:00 whoopsie
930 ? 00:00:00 mailmanctl
931 ? 00:00:00 python
932 ? 00:00:00 python
933 ? 00:00:00 python
934 ? 00:00:00 python
935 ? 00:00:00 python
936 ? 00:00:00 python
937 ? 00:00:00 python
938 ? 00:00:00 python
954 ? 00:00:00 opendkim
1062 ? 00:00:00 master
1068 ? 00:00:00 pickup
1069 ? 00:00:00 qmgr
1097 ? 00:00:00 saslauthd
1098 ? 00:00:00 saslauthd
1099 ? 00:00:00 saslauthd
1100 ? 00:00:00 saslauthd
1101 ? 00:00:00 saslauthd
1113 ? 00:00:00 flush-253:0
1115 ? 00:00:00 flush-253:16
1128 ? 00:00:00 snmpd
1631 ? 00:00:00 miniserv.pl
1641 ? 00:00:00 vnstatd
1696 ? 00:00:00 proftpd
1732 ? 00:00:00 apache2
1741 ? 00:00:00 apache2
1763 ? 00:00:00 apache2
1766 ? 00:00:00 miniserv.pl
1772 tty1 00:00:00 getty
1796 ? 00:00:00 anvil
1797 ? 00:00:00 log
1799 ? 00:00:00 config
1825 ? 00:00:00 ntpd
1831 ? 00:00:00 sshd
1834 ? 00:00:00 console-kit-dae
1901 ? 00:00:00 polkitd
1999 ? 00:00:00 sshd
2000 pts/0 00:00:00 bash
2098 ? 00:00:01 php5-cgi
2102 ? 00:00:00 apache2
2317 ? 00:00:00 apache2
2417 ? 00:00:00 /usr/share/webm
2438 ? 00:00:00 cleanup
2439 ? 00:00:00 php5-cgi
2440 ? 00:00:00 trivial-rewrite
2442 ? 00:00:00 local
2492 pts/0 00:00:00 ps
Thanks!