Current time: 12-23-2024, 08:12 PM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLSTATE[HY000] [2002]Can't connect to local MySQL server through socket '/var/run/my
Author Message
brainslush Offline
Newbie
*

Posts: 8
Joined: Feb 2010
Reputation: 0
Post: #1
SQLSTATE[HY000] [2002]Can't connect to local MySQL server through socket '/var/run/my
Sooo,
ich bin am verzweifeln....
Ich bekomme folgenden Fehler (Connection failed: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)), wenn ich eines Seite auf meinem VServer aufrufe.
Ich hab bereits die User-Tabelle probiert zu reparieren...
Doch es scheint, dass ISPCP Probleme hat den MySQL server zu starten...
Die mysql-Errorlogs sind leer.

Auszug aus der daemon.log:
Code:
Sep 15 12:08:12 v4101 mysqld[16064]: 100915 12:08:12  InnoDB: Started; log sequence number 0 4443040
Sep 15 12:08:12 v4101 mysqld[16064]: 100915 12:08:12 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Sep 15 12:08:12 v4101 mysqld[16064]: 100915 12:08:12 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 15 12:08:12 v4101 mysqld[16064]: 100915 12:08:12 [ERROR] Aborting
Sep 15 12:08:12 v4101 mysqld[16064]:
Sep 15 12:08:12 v4101 mysqld[16064]: 100915 12:08:12  InnoDB: Starting shutdown...
Sep 15 12:08:16 v4101 mysqld[16064]: 100915 12:08:16  InnoDB: Shutdown completed; log sequence number 0 4443040
Sep 15 12:08:16 v4101 mysqld[16064]: 100915 12:08:16 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 12:08:16 v4101 mysqld[16064]:
Sep 15 12:08:16 v4101 mysqld_safe[16183]: ended
Sep 15 12:08:20 v4101 /etc/init.d/mysql[16247]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 12:08:20 v4101 /etc/init.d/mysql[16247]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 12:08:20 v4101 /etc/init.d/mysql[16247]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 12:08:20 v4101 /etc/init.d/mysql[16247]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 15 12:08:20 v4101 /etc/init.d/mysql[16247]:
Wenn ich das richtig sehe, gibt es Probleme in der Portvergabe, doch wie ist dieses Problem aufgetreten?

# netstat -npl | grep 3306 wirft nichts aus...

Ich kann den MYSQL-Server per Shell starten.... ohne Fehlermeldung.

Gibt es eine Lösung für das Problem?

Danke
(This post was last modified: 09-15-2010 09:46 PM by brainslush.)
09-15-2010 10:37 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


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