Current time: 11-23-2024, 06:36 AM Hello There, Guest! (LoginRegister)


Post Reply 
[resolved] Mysql : Connection failed: SQLSTATE[HY000]
Author Message
theprincy Offline
Member
***

Posts: 311
Joined: Nov 2008
Reputation: 2
Post: #5
RE: Mysql : Connection failed: SQLSTATE[HY000]
hate google translate :@

then the problems I had I got around them on that server,

now on another machine

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

the solution seems easy enough to create the file myslqld.sock and start the MySQL daemon
unfortunately it is not so

root@torino:/var/run/mysqld# touch /var/run/mysqld/mysqld.sock
root@torino:/var/run/mysqld# chown mysql /var/run/mysqld/mysqld.sock
root@torino:/var/run/mysqld# !/etc
/etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
root@torino:/var/run/mysqld# ls -sl
totale 0
root@torino:/var/run/mysqld# ls -asl
totale 8
4 drwxrwxrwx 2 mysql root 4096 5 gen 10:25 .
4 drwxr-xr-x 14 root root 4096 5 gen 10:18 ..


the file mysqld.sock erased ideas for the solution?


__________________________________________________________________

mistero del informatica :
ha ripreso a funzionare da solo
(01-05-2010 05:13 AM)theprincy Wrote:  and now i have

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

how can I solve?

(01-05-2010 05:37 AM)motokochan Wrote:  What are you trying to do when you get this message?

message out when you sign on the panel that both sites
then mistakenly

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

I solved this way, but I'm not sure that is the correct way or if there are other solutions easier.

Then I deleted apache2 php5-mysql mysql-server and then install it again


while error

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

I completed these steps,

cd / var / run / mysqld /
rm-Rf mysqld.sock
touch / var / run / mysqld / mysqld.sock
chown mysql: mysql mysqld.sock
/ etc / init.d / mysql start
(This post was last modified: 01-05-2010 07:51 PM by theprincy.)
01-05-2010 07:35 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Mysql : Connection failed: SQLSTATE[HY000] - theprincy - 01-05-2010 07:35 PM

Forum Jump:


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