Package error mysql

1s440 · 06-05-2019, 03:12 AM

Hello all,

I am trying to install Percona mysql server on debian 8. But I am facing issues with the mysql. I have configured Mysql master and slave and it was working fine. When i started installing Percona, am unable to start Mysql and I often get the error

Code:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

when I try to force install the packages i get an error

Code:

error: subprocess paste was killed by signal (Broken pipe)

can anyone help me with this. I am unable to start mysql service.

pan64 · 06-05-2019, 09:59 AM

if I have to guess the current user has no sufficient right, most probably it should be put into a related group.
But without info it is only a guess.

1s440 · 06-06-2019, 06:36 AM

Quote:

Originally Posted by pan64

if I have to guess the current user has no sufficient right, most probably it should be put into a related group.
But without info it is only a guess.

Somehow I reinstalled again the Percona toolkit.

Butsomehow its not able to connect to the slave. Any idea on this?

Code:

 pt-table-checksum --replicate percona.checksums --ignore-databases=mysql h=localhost,u=root password=password
Checking if all tables can be checksummed ...
Starting checksum ...
Cannot connect to h=localhost,p=...,u=root
Diffs cannot be detected because no slaves were found.  Please read the --recursion-method documentation for information.