mac mysql terminal doesn't ask for password ERROR 1064
mysql database terminal supposed to ask me for password right after I typed 'mysql -u root -p'
Instead, it says "-->" after the command..
Last login: Tue Nov 27 16:00:34 on ttys000
Hyewons-iMac:~
home-mac$ /Applications/XAMPP/xamppfiles/bin/mysql ; exit;
Welcome to the MariaDB monitor. Commands end with ; or g.
Your
MariaDB connection id is 6
Server version: 10.1.37-MariaDB Source
distribution
Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.
Type 'help;' or 'h' for help.
Type 'c' to clear the current input statement.
MariaDB
[(none)]> mysql -u root -p
->
so I typed
;
after
-->
it goes
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near 'mysql -u root -p' at line 1
MariaDB [(none)]>
I have used mysql for WINDOWS and have never experienced it before..
what should I do??
I installed latest XAMPP 7.2.12-0 ( mysql-8.0.13-macos10.14-x86_64 also..) on MAC 10.12.6.
MySQL Database didn't work so changing mysql port to 3307 worked. Then I opened xampp > xamppfiles > bin > mysql
I have never set up for host name or password. I don't know I am doing right..
mysql xampp passwords mariadb
add a comment |
mysql database terminal supposed to ask me for password right after I typed 'mysql -u root -p'
Instead, it says "-->" after the command..
Last login: Tue Nov 27 16:00:34 on ttys000
Hyewons-iMac:~
home-mac$ /Applications/XAMPP/xamppfiles/bin/mysql ; exit;
Welcome to the MariaDB monitor. Commands end with ; or g.
Your
MariaDB connection id is 6
Server version: 10.1.37-MariaDB Source
distribution
Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.
Type 'help;' or 'h' for help.
Type 'c' to clear the current input statement.
MariaDB
[(none)]> mysql -u root -p
->
so I typed
;
after
-->
it goes
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near 'mysql -u root -p' at line 1
MariaDB [(none)]>
I have used mysql for WINDOWS and have never experienced it before..
what should I do??
I installed latest XAMPP 7.2.12-0 ( mysql-8.0.13-macos10.14-x86_64 also..) on MAC 10.12.6.
MySQL Database didn't work so changing mysql port to 3307 worked. Then I opened xampp > xamppfiles > bin > mysql
I have never set up for host name or password. I don't know I am doing right..
mysql xampp passwords mariadb
2
You are trying to start the mysql shell from within the mysql shell. TypeSHOW DATABASES;
instead and you will see that you're already logged in.
– digijay
Nov 27 '18 at 7:40
add a comment |
mysql database terminal supposed to ask me for password right after I typed 'mysql -u root -p'
Instead, it says "-->" after the command..
Last login: Tue Nov 27 16:00:34 on ttys000
Hyewons-iMac:~
home-mac$ /Applications/XAMPP/xamppfiles/bin/mysql ; exit;
Welcome to the MariaDB monitor. Commands end with ; or g.
Your
MariaDB connection id is 6
Server version: 10.1.37-MariaDB Source
distribution
Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.
Type 'help;' or 'h' for help.
Type 'c' to clear the current input statement.
MariaDB
[(none)]> mysql -u root -p
->
so I typed
;
after
-->
it goes
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near 'mysql -u root -p' at line 1
MariaDB [(none)]>
I have used mysql for WINDOWS and have never experienced it before..
what should I do??
I installed latest XAMPP 7.2.12-0 ( mysql-8.0.13-macos10.14-x86_64 also..) on MAC 10.12.6.
MySQL Database didn't work so changing mysql port to 3307 worked. Then I opened xampp > xamppfiles > bin > mysql
I have never set up for host name or password. I don't know I am doing right..
mysql xampp passwords mariadb
mysql database terminal supposed to ask me for password right after I typed 'mysql -u root -p'
Instead, it says "-->" after the command..
Last login: Tue Nov 27 16:00:34 on ttys000
Hyewons-iMac:~
home-mac$ /Applications/XAMPP/xamppfiles/bin/mysql ; exit;
Welcome to the MariaDB monitor. Commands end with ; or g.
Your
MariaDB connection id is 6
Server version: 10.1.37-MariaDB Source
distribution
Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.
Type 'help;' or 'h' for help.
Type 'c' to clear the current input statement.
MariaDB
[(none)]> mysql -u root -p
->
so I typed
;
after
-->
it goes
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near 'mysql -u root -p' at line 1
MariaDB [(none)]>
I have used mysql for WINDOWS and have never experienced it before..
what should I do??
I installed latest XAMPP 7.2.12-0 ( mysql-8.0.13-macos10.14-x86_64 also..) on MAC 10.12.6.
MySQL Database didn't work so changing mysql port to 3307 worked. Then I opened xampp > xamppfiles > bin > mysql
I have never set up for host name or password. I don't know I am doing right..
mysql xampp passwords mariadb
mysql xampp passwords mariadb
edited Nov 27 '18 at 9:09
digijay
5761715
5761715
asked Nov 27 '18 at 7:35
Annie JinAnnie Jin
11
11
2
You are trying to start the mysql shell from within the mysql shell. TypeSHOW DATABASES;
instead and you will see that you're already logged in.
– digijay
Nov 27 '18 at 7:40
add a comment |
2
You are trying to start the mysql shell from within the mysql shell. TypeSHOW DATABASES;
instead and you will see that you're already logged in.
– digijay
Nov 27 '18 at 7:40
2
2
You are trying to start the mysql shell from within the mysql shell. Type
SHOW DATABASES;
instead and you will see that you're already logged in.– digijay
Nov 27 '18 at 7:40
You are trying to start the mysql shell from within the mysql shell. Type
SHOW DATABASES;
instead and you will see that you're already logged in.– digijay
Nov 27 '18 at 7:40
add a comment |
1 Answer
1
active
oldest
votes
After typing this shell command:
$ mysql -u root -p
The prompt changes from $
(or #
) to:
MariaDB [(none)]>
At that point, you should type SQL statements, not try to re-enter the "mysql" commandline tool.
The "shell" is very much like "cmd" in Windows, so I am surprised that you went astray.
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%2f53494792%2fmac-mysql-terminal-doesnt-ask-for-password-error-1064%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
After typing this shell command:
$ mysql -u root -p
The prompt changes from $
(or #
) to:
MariaDB [(none)]>
At that point, you should type SQL statements, not try to re-enter the "mysql" commandline tool.
The "shell" is very much like "cmd" in Windows, so I am surprised that you went astray.
add a comment |
After typing this shell command:
$ mysql -u root -p
The prompt changes from $
(or #
) to:
MariaDB [(none)]>
At that point, you should type SQL statements, not try to re-enter the "mysql" commandline tool.
The "shell" is very much like "cmd" in Windows, so I am surprised that you went astray.
add a comment |
After typing this shell command:
$ mysql -u root -p
The prompt changes from $
(or #
) to:
MariaDB [(none)]>
At that point, you should type SQL statements, not try to re-enter the "mysql" commandline tool.
The "shell" is very much like "cmd" in Windows, so I am surprised that you went astray.
After typing this shell command:
$ mysql -u root -p
The prompt changes from $
(or #
) to:
MariaDB [(none)]>
At that point, you should type SQL statements, not try to re-enter the "mysql" commandline tool.
The "shell" is very much like "cmd" in Windows, so I am surprised that you went astray.
answered Nov 28 '18 at 3:01
Rick JamesRick James
69k561101
69k561101
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%2f53494792%2fmac-mysql-terminal-doesnt-ask-for-password-error-1064%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
2
You are trying to start the mysql shell from within the mysql shell. Type
SHOW DATABASES;
instead and you will see that you're already logged in.– digijay
Nov 27 '18 at 7:40