failing to run a specific version of mysql on my mac
I have two versions of mysql:
~ » brew info mysql nirohayon@Nirs-MBP-2
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:
mariadb (because mysql, mariadb, and percona install the same binaries.)
mariadb-connector-c (because both install plugins)
mysql-cluster (because mysql, mariadb, and percona install the same binaries.)
mysql-connector-c (because both install MySQL client libraries)
percona-server (because mysql, mariadb, and percona install the same binaries.)
/usr/local/Cellar/mysql/5.7.20_1 (323 files, 234.8MB) *
Poured from bottle on 2018-01-09 at 16:39:57
/usr/local/Cellar/mysql/8.0.11 (254 files, 232.6MB)
Poured from bottle on 2018-12-26 at 20:33:05
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Caveats
when I switch to 5.7.20_1 - i go mysql.server start all good and mysql open the shell.
when I switch to 8.0.11 - i go mysql.server start i get en error:
... ERROR! The server quit without updating PID file
(/usr/local/var/mysql/My-MBP-2.pid).
i dont get it, what do i miss here?
mysql homebrew
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
add a comment |
I have two versions of mysql:
~ » brew info mysql nirohayon@Nirs-MBP-2
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:
mariadb (because mysql, mariadb, and percona install the same binaries.)
mariadb-connector-c (because both install plugins)
mysql-cluster (because mysql, mariadb, and percona install the same binaries.)
mysql-connector-c (because both install MySQL client libraries)
percona-server (because mysql, mariadb, and percona install the same binaries.)
/usr/local/Cellar/mysql/5.7.20_1 (323 files, 234.8MB) *
Poured from bottle on 2018-01-09 at 16:39:57
/usr/local/Cellar/mysql/8.0.11 (254 files, 232.6MB)
Poured from bottle on 2018-12-26 at 20:33:05
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Caveats
when I switch to 5.7.20_1 - i go mysql.server start all good and mysql open the shell.
when I switch to 8.0.11 - i go mysql.server start i get en error:
... ERROR! The server quit without updating PID file
(/usr/local/var/mysql/My-MBP-2.pid).
i dont get it, what do i miss here?
mysql homebrew
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
1
how do you switch?
– Simonare
Dec 30 '18 at 23:22
add a comment |
I have two versions of mysql:
~ » brew info mysql nirohayon@Nirs-MBP-2
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:
mariadb (because mysql, mariadb, and percona install the same binaries.)
mariadb-connector-c (because both install plugins)
mysql-cluster (because mysql, mariadb, and percona install the same binaries.)
mysql-connector-c (because both install MySQL client libraries)
percona-server (because mysql, mariadb, and percona install the same binaries.)
/usr/local/Cellar/mysql/5.7.20_1 (323 files, 234.8MB) *
Poured from bottle on 2018-01-09 at 16:39:57
/usr/local/Cellar/mysql/8.0.11 (254 files, 232.6MB)
Poured from bottle on 2018-12-26 at 20:33:05
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Caveats
when I switch to 5.7.20_1 - i go mysql.server start all good and mysql open the shell.
when I switch to 8.0.11 - i go mysql.server start i get en error:
... ERROR! The server quit without updating PID file
(/usr/local/var/mysql/My-MBP-2.pid).
i dont get it, what do i miss here?
mysql homebrew
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
I have two versions of mysql:
~ » brew info mysql nirohayon@Nirs-MBP-2
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:
mariadb (because mysql, mariadb, and percona install the same binaries.)
mariadb-connector-c (because both install plugins)
mysql-cluster (because mysql, mariadb, and percona install the same binaries.)
mysql-connector-c (because both install MySQL client libraries)
percona-server (because mysql, mariadb, and percona install the same binaries.)
/usr/local/Cellar/mysql/5.7.20_1 (323 files, 234.8MB) *
Poured from bottle on 2018-01-09 at 16:39:57
/usr/local/Cellar/mysql/8.0.11 (254 files, 232.6MB)
Poured from bottle on 2018-12-26 at 20:33:05
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Caveats
when I switch to 5.7.20_1 - i go mysql.server start all good and mysql open the shell.
when I switch to 8.0.11 - i go mysql.server start i get en error:
... ERROR! The server quit without updating PID file
(/usr/local/var/mysql/My-MBP-2.pid).
i dont get it, what do i miss here?
mysql homebrew
mysql homebrew
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
asked Dec 26 '18 at 23:04
jack miaojack miao
470520
470520
1
how do you switch?
– Simonare
Dec 30 '18 at 23:22
add a comment |
1
how do you switch?
– Simonare
Dec 30 '18 at 23:22
1
1
how do you switch?
– Simonare
Dec 30 '18 at 23:22
how do you switch?
– Simonare
Dec 30 '18 at 23:22
add a comment |
1 Answer
1
active
oldest
votes
You cannot run two instances of mysql on the same data directory.
The pid file is used to guarantee that only one mysqld process is running at the same time on the same database.
If you want to run both MySQL 5.7 and MySQL 8, you have to define two different data directories.
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53938063%2ffailing-to-run-a-specific-version-of-mysql-on-my-mac%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
You cannot run two instances of mysql on the same data directory.
The pid file is used to guarantee that only one mysqld process is running at the same time on the same database.
If you want to run both MySQL 5.7 and MySQL 8, you have to define two different data directories.
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
add a comment |
You cannot run two instances of mysql on the same data directory.
The pid file is used to guarantee that only one mysqld process is running at the same time on the same database.
If you want to run both MySQL 5.7 and MySQL 8, you have to define two different data directories.
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
add a comment |
You cannot run two instances of mysql on the same data directory.
The pid file is used to guarantee that only one mysqld process is running at the same time on the same database.
If you want to run both MySQL 5.7 and MySQL 8, you have to define two different data directories.
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
You cannot run two instances of mysql on the same data directory.
The pid file is used to guarantee that only one mysqld process is running at the same time on the same database.
If you want to run both MySQL 5.7 and MySQL 8, you have to define two different data directories.
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
edited Dec 31 '18 at 7:52
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
answered Dec 30 '18 at 23:11
Ortomala LokniOrtomala Lokni
22.7k781127
22.7k781127
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53938063%2ffailing-to-run-a-specific-version-of-mysql-on-my-mac%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
1
how do you switch?
– Simonare
Dec 30 '18 at 23:22