O
O
Oleg Levshin2014-07-24 23:20:18
MySQL
Oleg Levshin, 2014-07-24 23:20:18

MySQL strange behavior on Ubuntu 14.04 with VestaCP installed, how to win?

Hello!
The situation is this. Decided to play around with DigitalOcean. Started a droplet with Ubuntu 14.04, on which I installed the VestaCP panel, which, in turn, took and pulled up AMP and the rest. MySQL behaves strangely: when the system is started/restarted, the process seems to start, but it does not allow to connect to itself (writes the standard error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/ mysqld/mysqld.sock' (2) ). If you do:

service mysql stop
service mysql start
starts working fine.
At the same time:
/etc/init.d/mysql stop - normally stops
/etc/init.d/mysql start- does not start, without swearing at the same time - it just freezes until you press ctrl + c.
What could be the reason for such a strange behavior of the subject?
Thank you.
root 1252 0.0 0.0 4444 332 ? S Jul24 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 2558 0.1 7.7 533968 39012 ? Sl 00:01 0:52 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql -- log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld .pid --socket=/var/run/mysqld/mysqld.sock --port=3306
mysql 21379 0.1 6.3 356124 31708 ? Ssl 11:37 0:00 /usr/sbin/mysqld
root 21520 0.0 0.1 8864 644 pts/0 S+ 11:37 0:00 grep mysql
The output of tail -n 100 /var/log/mysql.log is empty. netstat
output : https://dl.dropboxusercontent.com/u/11461820/do_ne...

Answer the question

In order to leave comments, you need to log in

4 answer(s)
A
Anton Solomonov, 2014-07-25
@Wendor

Stop mysql, then start and show the results of these commands:
ps auwx | grep mysql
tail -n 100 /var/log/mysql.log
netstat -npl

O
Oleg Levshin, 2014-07-25
@LevshinO

Updated the title post.

I
Igor, 2014-07-25
@merryjane

Is anything written to /var/log/mysql/error.log ?

A
Anton Teremshonok, 2015-01-28
@TerAnYu

Thought I was the only one with this problem.
How did you solve this problem?
At home, I see (htop) when I do service mysql stop that the service has stopped and after a couple of moments it starts again by itself.
How to fill his hands on his hands, so that he would not start without permission?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question