Keine Mysql Verbindung zur Datenbank?

CranK[491] · 2. Februar 2020

Hallo ich benötige eure Hilfe und zwar lädt der Server ganz Normal jedoch kommen diese Fehler bei mir im mysql.log

ich habe schon hin und her probiert bin nämlich auf ein VServer/root gewechselt und jetzt kommt das

Code

[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadFraktion()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadFVehicles()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadFRank()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadHouses()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadOrg()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadOthers()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadBizes()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadTanken()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadGangwar()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadGutscheine()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[15:06:09] [ERROR] CMySQLQuery::Execute[LoadDrogen()] - (error #2006) MySQL server has gone away
[15:06:09] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Alles anzeigen

Bitte um eure Hilfe

vielen Dank

Kaliber · 2. Februar 2020

Zitat von CranK[491]

MySQL server has gone away

Tjoa, was soll man sagen, der hat seinen Koffer gepackt und ist weg

Es sieht so aus, als ob der MySQL Server gar nicht gestartet ist?

sudo start mysql

(Oder je nach Distribution, google den Command xD)

CranK[491] · 2. Februar 2020

leider mein Problem nicht gelöst

fendix · 2. Februar 2020

Zitat
I once had this problem and solved it by installing mysql-server, so make sure that you have installed the mysql-server, not the mysql-client or something else.

That error means the file /var/run/mysqld/mysqld.sock doesn't exists, if you didn't install mysql-server, then the file would not exist. But if the mysql-server is already installed and is running, then you need to check the config files.

The config files are:
Code
/etc/my.cnf
/etc/mysql/my.cnf
/var/lib/mysql/my.cnf
In /etc/my.cnf, the socket file config may be /tmp/mysql.sock and in /etc/mysql/my.cnf the socket file config may be /var/run/mysqld/mysqld.sock. So, remove or rename /etc/mysql/my.cnf, let mysql use /etc/my.cnf, then the problem may solved.

CranK[491] · 2. Februar 2020

Lösung anstatt "localhost" -> "127.0.0.1"

Keine Mysql Verbindung zur Datenbank?

breadfish.de 12. März 2022

Ähnliche Themen

[SAMMELTHREAD] Kleine Scripting Fragen

MySQL Datenbank verbindet sich nicht

Fehle bei MySQL