“Could not create unix socket lock file” with MySQL 5.7.10 on OS X 10.11.2
I've been trying to install MySQL 5.7 on OS X El Capitan using Homebrew, however when it came to getting the server up and running, I cannot seem to get a lock file created.
When I run mysqld_safe, it logs errors to a file and the only relevant message that I saw was this:
2015-12-13T19:48:09.270970Z 0 [ERROR] Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
Looking at the configuration, if I run mysql_config | grep -- --socket, I see this:
--socket [/tmp/mysql.sock]
It seems that the socket is getting created for a split second, but if it tries to make the lock file, it aborts. What is going on?
macos mysql homebrew sockets osx-el-capitan
asked Dec 13 '15 at 20:02
MarkMark
1115
add a comment |
I've been trying to install MySQL 5.7 on OS X El Capitan using Homebrew, however when it came to getting the server up and running, I cannot seem to get a lock file created.
When I run mysqld_safe, it logs errors to a file and the only relevant message that I saw was this:
2015-12-13T19:48:09.270970Z 0 [ERROR] Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
Looking at the configuration, if I run mysql_config | grep -- --socket, I see this:
--socket [/tmp/mysql.sock]
It seems that the socket is getting created for a split second, but if it tries to make the lock file, it aborts. What is going on?
macos mysql homebrew sockets osx-el-capitan
asked Dec 13 '15 at 20:02
MarkMark
1115
add a comment |
I've been trying to install MySQL 5.7 on OS X El Capitan using Homebrew, however when it came to getting the server up and running, I cannot seem to get a lock file created.
When I run mysqld_safe, it logs errors to a file and the only relevant message that I saw was this:
2015-12-13T19:48:09.270970Z 0 [ERROR] Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
Looking at the configuration, if I run mysql_config | grep -- --socket, I see this:
--socket [/tmp/mysql.sock]
It seems that the socket is getting created for a split second, but if it tries to make the lock file, it aborts. What is going on?
macos mysql homebrew sockets osx-el-capitan
asked Dec 13 '15 at 20:02
MarkMark
1115
I've been trying to install MySQL 5.7 on OS X El Capitan using Homebrew, however when it came to getting the server up and running, I cannot seem to get a lock file created.
When I run mysqld_safe, it logs errors to a file and the only relevant message that I saw was this:
2015-12-13T19:48:09.270970Z 0 [ERROR] Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
Looking at the configuration, if I run mysql_config | grep -- --socket, I see this:
--socket [/tmp/mysql.sock]
It seems that the socket is getting created for a split second, but if it tries to make the lock file, it aborts. What is going on?
macos mysql homebrew sockets osx-el-capitan
macos mysql homebrew sockets osx-el-capitan
asked Dec 13 '15 at 20:02
MarkMark
1115
asked Dec 13 '15 at 20:02
MarkMark
1115
asked Dec 13 '15 at 20:02
MarkMark
1115
asked Dec 13 '15 at 20:02
MarkMark
1115
asked Dec 13 '15 at 20:02
MarkMark
1115
1115
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I think this is a bug in mysql 5.7.
In my case, I am building a docker container. I went ahead and changed the version of mysql I installed to 5.6 through apt-get and it fixed the issue immediately.
apt-get install software-properties-common python-software-properties
add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
apt-get update
apt-get install mysql-client-5.6 mysql-server-5.6
Hope this helps.
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1012913%2fcould-not-create-unix-socket-lock-file-with-mysql-5-7-10-on-os-x-10-11-2%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
I think this is a bug in mysql 5.7.
In my case, I am building a docker container. I went ahead and changed the version of mysql I installed to 5.6 through apt-get and it fixed the issue immediately.
apt-get install software-properties-common python-software-properties
add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
apt-get update
apt-get install mysql-client-5.6 mysql-server-5.6
Hope this helps.
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
add a comment |
I think this is a bug in mysql 5.7.
In my case, I am building a docker container. I went ahead and changed the version of mysql I installed to 5.6 through apt-get and it fixed the issue immediately.
apt-get install software-properties-common python-software-properties
add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
apt-get update
apt-get install mysql-client-5.6 mysql-server-5.6
Hope this helps.
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
add a comment |
I think this is a bug in mysql 5.7.
In my case, I am building a docker container. I went ahead and changed the version of mysql I installed to 5.6 through apt-get and it fixed the issue immediately.
apt-get install software-properties-common python-software-properties
add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
apt-get update
apt-get install mysql-client-5.6 mysql-server-5.6
Hope this helps.
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
I think this is a bug in mysql 5.7.
In my case, I am building a docker container. I went ahead and changed the version of mysql I installed to 5.6 through apt-get and it fixed the issue immediately.
apt-get install software-properties-common python-software-properties
add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
apt-get update
apt-get install mysql-client-5.6 mysql-server-5.6
Hope this helps.
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
answered Feb 3 '17 at 21:33
Brad FellowsBrad Fellows
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1012913%2fcould-not-create-unix-socket-lock-file-with-mysql-5-7-10-on-os-x-10-11-2%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
