Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
is it timing out or is there something missing? i tried it last night and also today and the error persists, anyone have troubleshoot ideas?
Blogs > Raithed |
Raithed
China7077 Posts
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) is it timing out or is there something missing? i tried it last night and also today and the error persists, anyone have troubleshoot ideas? | ||
pirate cod
810 Posts
might help | ||
dyodyo
Philippines578 Posts
Or if the mysql is hosted on a different machine, try using either the IP address instead of the hostname of the mysql server. | ||
Raithed
China7077 Posts
On October 02 2008 04:44 dyodyo wrote: Try using '127.0.0.1' instead of 'localhost' (or vice versa) in the 'host' field of your connection string Or if the mysql is hosted on a different machine, try using either the IP address instead of the hostname of the mysql server. is that IP universal? Can't connect to MySQL server on '127.0.0.1' (111) got that, im only guessing "111" is the error number. | ||
Raithed
China7077 Posts
there isnt a manual. | ||
dyodyo
Philippines578 Posts
On October 02 2008 04:55 Raithed wrote: Show nested quote + On October 02 2008 04:44 dyodyo wrote: Try using '127.0.0.1' instead of 'localhost' (or vice versa) in the 'host' field of your connection string Or if the mysql is hosted on a different machine, try using either the IP address instead of the hostname of the mysql server. is that IP universal? Can't connect to MySQL server on '127.0.0.1' (111) got that, im only guessing "111" is the error number. '127.0.0.1' is the ip address of 'localhost', which is the local machine where the web server is running. Is your mysql server hosted on the same machine as your webserver or somewhere else? Have you tried using 'localhost' in the connection string? | ||
Raithed
China7077 Posts
| ||
dyodyo
Philippines578 Posts
Anyways, do you have root access to the server (ie can access it via ssh or putty)? In the first error message, it seems that mysql cannot find the socket file. The only way (at least to me) to 'correct' this is by editing the my.cnf (mysql configuration) and checking for correct file/folder permissions. Edit: Found this link buried in my bookmarks, it should help: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html | ||
Raithed
China7077 Posts
| ||
dyodyo
Philippines578 Posts
| ||
wo0py
Netherlands922 Posts
| ||
Raithed
China7077 Posts
| ||
dyodyo
Philippines578 Posts
| ||
Raithed
China7077 Posts
| ||
dyodyo
Philippines578 Posts
On October 02 2008 09:26 Raithed wrote: if theyre able to get into my account, meaning the server account. No, they can use their own account to modify your files, thats what the file permission 777 means. see: http://en.wikipedia.org/wiki/File_system_permissions#Octal_notation | ||
Raithed
China7077 Posts
| ||
| ||
ESL Pro Tour
Spring 2024 - EU Playoffs D2
GunGFuBanDa vs Spirit
Elazer vs Krystianer
SKillous vs MaxPax
ESL.tv4782
ComeBackTV 898
TaKeTV 431
IndyStarCraft 348
SteadfastSC134
CosmosSc2 87
BRAT_OK 74
3DClanTV 74
[ Submit Event ] |
StarCraft 2 StarCraft: Brood War Britney 54105 Dota 2Calm 1894 Shuttle 1027 EffOrt 700 firebathero 528 actioN 467 ggaemo 335 BeSt 330 Leta 236 Snow 222 [ Show more ] Counter-Strike Other Games B2W.Neo819 DeMusliM668 Mlord659 crisheroes613 Hui .567 Lowko345 KnowMe116 QueenE112 NuckleDu102 nookyyy 89 Trikslyr87 Organizations
StarCraft 2 • CranKy Ducklings133 StarCraft: Brood War• intothetv • Kozan • Poblha • Migwel • Laughngamez YouTube • aXEnki • LaughNgamez Trovo • IndyKCrew • Gussbus League of Legends Other Games |
Big Brain Bouts
Korean StarCraft League
Afreeca Starleague
hero vs Soulkey
AfreecaTV Pro Series
Reynor vs Cure
ESL Pro Tour
World Team League
ESL Pro Tour
BSL
Zhanhun vs DragOn
Dewalt vs Sziky
CSO Cup
Replay Cast
[ Show More ] Sparkling Tuna Cup
ESL Pro Tour
World Team League
ESL Pro Tour
BSL
Gypsy vs Bonyth
Mihu vs XiaoShuai
ESL Open Cup
ESL Open Cup
ESL Open Cup
ESL Pro Tour
ESL Pro Tour
ESL Pro Tour
|
|