Why remote login MYSQL database -p option must be concatenated with the password? The Next...
Where do students learn to solve polynomial equations these days?
Can this note be analyzed as a non-chord tone?
Computationally populating tables with probability data
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
How to Implement Deterministic Encryption Safely in .NET
Why do we say 'Un seul M' and not 'Une seule M' even though M is a "consonne"
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
Can Sneak Attack be used when hitting with an improvised weapon?
Is it professional to write unrelated content in an almost-empty email?
It is correct to match light sources with the same color temperature?
What happened in Rome, when the western empire "fell"?
Players Circumventing the limitations of Wish
Strange use of "whether ... than ..." in official text
What is the process for cleansing a very negative action
Airplane gently rocking its wings during whole flight
Is French Guiana a (hard) EU border?
Purpose of level-shifter with same in and out voltages
Are the names of these months realistic?
Reshaping json / reparing json inside shell script (remove trailing comma)
Is it convenient to ask the journal's editor for two additional days to complete a review?
Cannot shrink btrfs filesystem although there is still data and metadata space left : ERROR: unable to resize '/home': No space left on device
Do scriptures give a method to recognize a truly self-realized person/jivanmukta?
Why am I getting "Static method cannot be referenced from a non static context: String String.valueOf(Object)"?
Is it ever safe to open a suspicious HTML file (e.g. email attachment)?
Why remote login MYSQL database -p option must be concatenated with the password?
The Next CEO of Stack OverflowHow to install MySQL on Windows 7MySQL Post-Installation on a Mac OSX Snow Leopardmysql how to fix Access denied for user 'root'@'localhost'Debian: Login to mysql doesn't work#1045 - Access denied for user 'root'@'localhost' (using password: NO)MySQL connection works on CLI, but not on WorkbenchOpenSuSE 10.2: create MySQL database with “Access denied for user 'root'@'localhost'”Not able to use MySQL commands after installationCan't setup/clean reinstall MariaDB/MySQL on Debian Stretch 9Encountering password error in re-installing MYSQL server
for example,when I login MYSQL from remote,the following command will return a password request.I input the password,and it failed.
[root@iz8a1fch6ye8rgz ~]# mysql -u root -p -h myhost.com
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'119.21.252.94' (using password: YES)
then I changed the command to another format,concatenate password with -p,it works!
[root@iz8a1fch6ye8rgz ~]# mysql -u root -pMYPASSWORD -h myhost.com
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MySQL connection id is 384330
Server version: 5.7.18-log 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.
MySQL [(none)]>
Anyone know the reason? I'm confused.
passwords mysql
add a comment |
for example,when I login MYSQL from remote,the following command will return a password request.I input the password,and it failed.
[root@iz8a1fch6ye8rgz ~]# mysql -u root -p -h myhost.com
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'119.21.252.94' (using password: YES)
then I changed the command to another format,concatenate password with -p,it works!
[root@iz8a1fch6ye8rgz ~]# mysql -u root -pMYPASSWORD -h myhost.com
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MySQL connection id is 384330
Server version: 5.7.18-log 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.
MySQL [(none)]>
Anyone know the reason? I'm confused.
passwords mysql
add a comment |
for example,when I login MYSQL from remote,the following command will return a password request.I input the password,and it failed.
[root@iz8a1fch6ye8rgz ~]# mysql -u root -p -h myhost.com
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'119.21.252.94' (using password: YES)
then I changed the command to another format,concatenate password with -p,it works!
[root@iz8a1fch6ye8rgz ~]# mysql -u root -pMYPASSWORD -h myhost.com
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MySQL connection id is 384330
Server version: 5.7.18-log 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.
MySQL [(none)]>
Anyone know the reason? I'm confused.
passwords mysql
for example,when I login MYSQL from remote,the following command will return a password request.I input the password,and it failed.
[root@iz8a1fch6ye8rgz ~]# mysql -u root -p -h myhost.com
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'119.21.252.94' (using password: YES)
then I changed the command to another format,concatenate password with -p,it works!
[root@iz8a1fch6ye8rgz ~]# mysql -u root -pMYPASSWORD -h myhost.com
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MySQL connection id is 384330
Server version: 5.7.18-log 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.
MySQL [(none)]>
Anyone know the reason? I'm confused.
passwords mysql
passwords mysql
asked 35 mins ago
傅继晗傅继晗
13
13
add a comment |
add a comment |
0
active
oldest
votes
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%2f1419792%2fwhy-remote-login-mysql-database-p-option-must-be-concatenated-with-the-password%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1419792%2fwhy-remote-login-mysql-database-p-option-must-be-concatenated-with-the-password%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