How can I access the mysql community server in terminal or by GUI?
I downloaded the 'MySQL Community Server' and installed it on my macOS (10.13.6).
How can I access the MySLQ Community Server? Where is it? I can only find that there is a new mySQL pane in the 'system preference'.
The terminal shows me: command not found as below:
$mysql
-bash: mysql: command not found
I'm new about this. Is the right usage of mySQL by GUI is firstly install the 'mySQL Community Server' and then install the 'MySQL Workbench'?
mysql macos
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
asked Nov 23 '18 at 9:29
sonictlsonictl
136
add a comment |
I downloaded the 'MySQL Community Server' and installed it on my macOS (10.13.6).
How can I access the MySLQ Community Server? Where is it? I can only find that there is a new mySQL pane in the 'system preference'.
The terminal shows me: command not found as below:
$mysql
-bash: mysql: command not found
I'm new about this. Is the right usage of mySQL by GUI is firstly install the 'mySQL Community Server' and then install the 'MySQL Workbench'?
mysql macos
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
asked Nov 23 '18 at 9:29
sonictlsonictl
136
is the mysql command in your PATH?
– treyBake
Nov 23 '18 at 9:29
when you type the command 'mysql', the terminal should understand where to find the mysql program. For this, it will refer to PATH. Try adding the location of 'bin' folder of mysql installation to PATH and restart the terminal.
– Praveen E
Nov 23 '18 at 9:58
add a comment |
I downloaded the 'MySQL Community Server' and installed it on my macOS (10.13.6).
How can I access the MySLQ Community Server? Where is it? I can only find that there is a new mySQL pane in the 'system preference'.
The terminal shows me: command not found as below:
$mysql
-bash: mysql: command not found
I'm new about this. Is the right usage of mySQL by GUI is firstly install the 'mySQL Community Server' and then install the 'MySQL Workbench'?
mysql macos
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
asked Nov 23 '18 at 9:29
sonictlsonictl
136
I downloaded the 'MySQL Community Server' and installed it on my macOS (10.13.6).
How can I access the MySLQ Community Server? Where is it? I can only find that there is a new mySQL pane in the 'system preference'.
The terminal shows me: command not found as below:
$mysql
-bash: mysql: command not found
I'm new about this. Is the right usage of mySQL by GUI is firstly install the 'mySQL Community Server' and then install the 'MySQL Workbench'?
mysql macos
mysql macos
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
asked Nov 23 '18 at 9:29
sonictlsonictl
136
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
asked Nov 23 '18 at 9:29
sonictlsonictl
136
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
edited Nov 24 '18 at 1:58
Jonathan Leffler
566k916781030
566k916781030
asked Nov 23 '18 at 9:29
sonictlsonictl
136
asked Nov 23 '18 at 9:29
sonictlsonictl
136
asked Nov 23 '18 at 9:29
sonictlsonictl
136
136
is the mysql command in your PATH?
– treyBake
Nov 23 '18 at 9:29
when you type the command 'mysql', the terminal should understand where to find the mysql program. For this, it will refer to PATH. Try adding the location of 'bin' folder of mysql installation to PATH and restart the terminal.
– Praveen E
Nov 23 '18 at 9:58
add a comment |
is the mysql command in your PATH?
– treyBake
Nov 23 '18 at 9:29
when you type the command 'mysql', the terminal should understand where to find the mysql program. For this, it will refer to PATH. Try adding the location of 'bin' folder of mysql installation to PATH and restart the terminal.
– Praveen E
Nov 23 '18 at 9:58
is the mysql command in your PATH?
– treyBake
Nov 23 '18 at 9:29
is the mysql command in your PATH?
– treyBake
Nov 23 '18 at 9:29
when you type the command 'mysql', the terminal should understand where to find the mysql program. For this, it will refer to PATH. Try adding the location of 'bin' folder of mysql installation to PATH and restart the terminal.
– Praveen E
Nov 23 '18 at 9:58
when you type the command 'mysql', the terminal should understand where to find the mysql program. For this, it will refer to PATH. Try adding the location of 'bin' folder of mysql installation to PATH and restart the terminal.
– Praveen E
Nov 23 '18 at 9:58
add a comment |
1 Answer
1
active
oldest
votes
Typically, the MySQL server (MySQL Community Server) can work with terminal. Use the mysql command in terminal after the path of mysql (/usr/local/mysql/bin) has been added into PATH(modify the '~/.bash_profile' file for instance).
If one needs GUI, download a MySQL Workbench, and let it connect to the MySQL Server. The operations done by commands in the terminal can be done via the UI of MySQL Workbench.
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
answered Nov 24 '18 at 1:24
sonictlsonictl
136
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%2f53443891%2fhow-can-i-access-the-mysql-community-server-in-terminal-or-by-gui%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
Typically, the MySQL server (MySQL Community Server) can work with terminal. Use the mysql command in terminal after the path of mysql (/usr/local/mysql/bin) has been added into PATH(modify the '~/.bash_profile' file for instance).
If one needs GUI, download a MySQL Workbench, and let it connect to the MySQL Server. The operations done by commands in the terminal can be done via the UI of MySQL Workbench.
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
answered Nov 24 '18 at 1:24
sonictlsonictl
136
add a comment |
Typically, the MySQL server (MySQL Community Server) can work with terminal. Use the mysql command in terminal after the path of mysql (/usr/local/mysql/bin) has been added into PATH(modify the '~/.bash_profile' file for instance).
If one needs GUI, download a MySQL Workbench, and let it connect to the MySQL Server. The operations done by commands in the terminal can be done via the UI of MySQL Workbench.
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
answered Nov 24 '18 at 1:24
sonictlsonictl
136
add a comment |
Typically, the MySQL server (MySQL Community Server) can work with terminal. Use the mysql command in terminal after the path of mysql (/usr/local/mysql/bin) has been added into PATH(modify the '~/.bash_profile' file for instance).
If one needs GUI, download a MySQL Workbench, and let it connect to the MySQL Server. The operations done by commands in the terminal can be done via the UI of MySQL Workbench.
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
answered Nov 24 '18 at 1:24
sonictlsonictl
136
Typically, the MySQL server (MySQL Community Server) can work with terminal. Use the mysql command in terminal after the path of mysql (/usr/local/mysql/bin) has been added into PATH(modify the '~/.bash_profile' file for instance).
If one needs GUI, download a MySQL Workbench, and let it connect to the MySQL Server. The operations done by commands in the terminal can be done via the UI of MySQL Workbench.
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
answered Nov 24 '18 at 1:24
sonictlsonictl
136
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
edited Nov 24 '18 at 1:59
Jonathan Leffler
566k916781030
566k916781030
answered Nov 24 '18 at 1:24
sonictlsonictl
136
answered Nov 24 '18 at 1:24
sonictlsonictl
136
answered Nov 24 '18 at 1:24
sonictlsonictl
136
136
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%2f53443891%2fhow-can-i-access-the-mysql-community-server-in-terminal-or-by-gui%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
is the mysql command in your PATH?
– treyBake
Nov 23 '18 at 9:29
when you type the command 'mysql', the terminal should understand where to find the mysql program. For this, it will refer to PATH. Try adding the location of 'bin' folder of mysql installation to PATH and restart the terminal.
– Praveen E
Nov 23 '18 at 9:58