Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) The Next CEO of Stack OverflowProblem running mysql client, cannot connect to mysql serverCan't connect to local MySQL server through socket“Can't connect to local MySQL server through socket” and deleted socketCan't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)How to resolve “Can't connect to local MySQL server through socket” errorCan't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminalMysql “Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)”Can't connect to local MySQL server through socket '/opt/local/var/run/percona/mysqld.sock'
What is the process for cleansing a very negative action
Which one is the true statement?
Is there a reasonable and studied concept of reduction between regular languages?
What CSS properties can the br tag have?
What was Carter Burke's job for "the company" in Aliens?
"Eavesdropping" vs "Listen in on"
Purpose of level-shifter with same in and out voltages
How did Beeri the Hittite come up with naming his daughter Yehudit?
Players Circumventing the limitations of Wish
What steps are necessary to read a Modern SSD in Medieval Europe?
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
How to use ReplaceAll on an expression that contains a rule
Getting Stale Gas Out of a Gas Tank w/out Dropping the Tank
Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
Scary film where a woman has vaginal teeth
Why don't programming languages automatically manage the synchronous/asynchronous problem?
Yu-Gi-Oh cards in Python 3
Strange use of "whether ... than ..." in official text
What happened in Rome, when the western empire "fell"?
Is it ok to trim down a tube patch?
Spaces in which all closed sets are regular closed
Why am I getting "Static method cannot be referenced from a non static context: String String.valueOf(Object)"?
Can I calculate next year's exemptions based on this year's refund/amount owed?
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
The Next CEO of Stack OverflowProblem running mysql client, cannot connect to mysql serverCan't connect to local MySQL server through socket“Can't connect to local MySQL server through socket” and deleted socketCan't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)How to resolve “Can't connect to local MySQL server through socket” errorCan't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminalMysql “Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)”Can't connect to local MySQL server through socket '/opt/local/var/run/percona/mysqld.sock'
The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6.
I type mysql -u username -p and I get this message:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
any idea what happened? How to fix it?
mysql debian socket
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6.
I type mysql -u username -p and I get this message:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
any idea what happened? How to fix it?
mysql debian socket
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6.
I type mysql -u username -p and I get this message:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
any idea what happened? How to fix it?
mysql debian socket
The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6.
I type mysql -u username -p and I get this message:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
any idea what happened? How to fix it?
mysql debian socket
mysql debian socket
asked Oct 30 '12 at 0:13
MitchMitch
3113
3113
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
When the server's IP was changed, the bind-address in /etc/mysql/my.cnf was still set to the old IP, which caused this problem.
add a comment |
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f443545%2fcant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
When the server's IP was changed, the bind-address in /etc/mysql/my.cnf was still set to the old IP, which caused this problem.
add a comment |
When the server's IP was changed, the bind-address in /etc/mysql/my.cnf was still set to the old IP, which caused this problem.
add a comment |
When the server's IP was changed, the bind-address in /etc/mysql/my.cnf was still set to the old IP, which caused this problem.
When the server's IP was changed, the bind-address in /etc/mysql/my.cnf was still set to the old IP, which caused this problem.
answered Oct 30 '12 at 10:10
MitchMitch
3113
3113
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f443545%2fcant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown