Erro ao acessar o banco mysql

ricardoifc
(usa Ubuntu)

Enviado em 25/10/2018 - 11:57h

Eu digito mysql -u root -p

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

Alguma dica?

danniel-lara
(usa Fedora)

Enviado em 25/10/2018 - 13:24h

verifica se o serviço do mysq esta rodando

ricardoifc
(usa Ubuntu)

Enviado em 25/10/2018 - 14:10h

Ola boa tarde, obgdo por responder. O que aconteceu foi o seguinte, eu tinha o glpi e msql rodando normalmente e tentei instalar outra aplicacao e acabei rodando o comando para instalar o mariadb, foi o que aconteceu hehehe

danniel-lara
(usa Fedora)

Enviado em 25/10/2018 - 14:56h

tu tens o backup do seu mysql ?

ricardoifc
(usa Ubuntu)

Enviado em 25/10/2018 - 15:10h

pior que nao tenho :/

ricardoifc
(usa Ubuntu)

Enviado em 25/10/2018 - 16:13h

root@SRVATEND:~# service mysql status
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2018-10-25 11:26:30 -03; 3h 46mi
Docs: man:systemd-sysv-generator(8)
Process: 1937 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE

Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: 0 processes alive and '/usr/bi
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: [52B blob data]
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: error: 'Can't connect to local
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: Check that mysqld is running a
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]:
Oct 25 11:26:30 SRVATEND mysql[1937]: ...fail!
Oct 25 11:26:30 SRVATEND systemd[1]: mysql.service: Control process exited, code
Oct 25 11:26:30 SRVATEND systemd[1]: Failed to start LSB: Start and stop the mys
Oct 25 11:26:30 SRVATEND systemd[1]: mysql.service: Unit entered failed state.
Oct 25 11:26:30 SRVATEND systemd[1]: mysql.service: Failed with result 'exit-cod
lines 1-16/16 (END)...skipping...
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2018-10-25 11:26:30 -03; 3h 46min ago
Docs: man:systemd-sysv-generator(8)
Process: 1937 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: [52B blob data]
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 25 11:26:30 SRVATEND /etc/init.d/mysql[2249]:
Oct 25 11:26:30 SRVATEND mysql[1937]: ...fail!
Oct 25 11:26:30 SRVATEND systemd[1]: mysql.service: Control process exited, code=exited status=1
Oct 25 11:26:30 SRVATEND systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Oct 25 11:26:30 SRVATEND systemd[1]: mysql.service: Unit entered failed state.
Oct 25 11:26:30 SRVATEND systemd[1]: mysql.service: Failed with result 'exit-code'.