Current time: 12-28-2024, 11:26 AM Hello There, Guest! (LoginRegister)


Post Reply 
[ CLOSED ] Connection failed: SQLSTATE[HY000] [2002]
Author Message
CHBIE Offline
Junior Member
*

Posts: 225
Joined: May 2008
Reputation: 11
Post: #1
[ CLOSED ] Connection failed: SQLSTATE[HY000] [2002]
Hi Leute

letzte Nacht den Server normal Heruntergefahren und Heute Morgen gestartet es erscheint folgende Fehlermeldung:

Code:
Connection failed: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Die beiden Logs (mysql.err & mysql.log) sind LEER!

Ferner fehlen folgende Einträge in der /var/run/mysqld:

Code:
mysqld.pid
mysqld.sock

habe die zwei Einträge Manuel angelegt, Besitzer auf mysql geändert, schreibrechte angepasst.

Server neu gestartet und die Einträge in /var/run/mysqld waren wieder weg!

weiss jemand Rat?

Ausgabe in der Konsole:

Code:
alpha:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

Code:
alpha:~# mysqld
090202  8:41:15  InnoDB: Started; log sequence number 0 43655
090202  8:41:15 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
090202  8:41:15 [Note] Starting crash recovery...
090202  8:41:15 [Note] Crash recovery finished.
090202  8:41:15 [ERROR] mysqld: Incorrect information in file: './mysql/user.frm'
090202  8:41:15 [ERROR] mysqld: Incorrect information in file: './mysql/user.frm'
090202  8:41:15 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/user.frm'

wo finde ich diesen Eintrag: ./mysql/user.frm

Danke und Gruss CHBIE
(This post was last modified: 02-02-2009 06:51 PM by CHBIE.)
02-02-2009 03:54 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
[ CLOSED ] Connection failed: SQLSTATE[HY000] [2002] - CHBIE - 02-02-2009 03:54 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)