Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public...
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two minutes. I got the error "Access denied for user 'root'@'%'". To solve this error I tried the below queries.
GRANT ALL PRIVILEGES ON database.* TO 'root'@'%' IDENTIFIED BY 'PWD';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'root'@'%
select * from mysql.user where User='root';
Now after executing these queries the error was solved and the event scheduler worked.
But now I am unable to login using the query browser in my system. I am getting another error when I try to login using the query browser from my system.
The error I am getting when I try to login using the query browser from my system is this --> "Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)". How can I solve this error?
mysql
edited May 5 '16 at 14:29
Rick James
43.8k22259
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
bumped to the homepage by Community♦ 23 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two minutes. I got the error "Access denied for user 'root'@'%'". To solve this error I tried the below queries.
GRANT ALL PRIVILEGES ON database.* TO 'root'@'%' IDENTIFIED BY 'PWD';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'root'@'%
select * from mysql.user where User='root';
Now after executing these queries the error was solved and the event scheduler worked.
But now I am unable to login using the query browser in my system. I am getting another error when I try to login using the query browser from my system.
The error I am getting when I try to login using the query browser from my system is this --> "Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)". How can I solve this error?
mysql
edited May 5 '16 at 14:29
Rick James
43.8k22259
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
bumped to the homepage by Community♦ 23 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Please send the output of below queries:select user,host from mysql.user;andshow grants for root@'%';
– Geetanjali
May 5 '16 at 12:28
1
Possible duplicate of How to securely connect app and database servers?
– hot2use
Oct 6 '17 at 21:21
@Geetanjali that does seem like a leak of personal information. I would probably just suggest how the asker could use that information to tell how that would be helpful for diagnosis
– jcolebrand♦
Jul 29 '18 at 23:41
add a comment |
I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two minutes. I got the error "Access denied for user 'root'@'%'". To solve this error I tried the below queries.
GRANT ALL PRIVILEGES ON database.* TO 'root'@'%' IDENTIFIED BY 'PWD';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'root'@'%
select * from mysql.user where User='root';
Now after executing these queries the error was solved and the event scheduler worked.
But now I am unable to login using the query browser in my system. I am getting another error when I try to login using the query browser from my system.
The error I am getting when I try to login using the query browser from my system is this --> "Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)". How can I solve this error?
mysql
edited May 5 '16 at 14:29
Rick James
43.8k22259
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two minutes. I got the error "Access denied for user 'root'@'%'". To solve this error I tried the below queries.
GRANT ALL PRIVILEGES ON database.* TO 'root'@'%' IDENTIFIED BY 'PWD';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'root'@'%
select * from mysql.user where User='root';
Now after executing these queries the error was solved and the event scheduler worked.
But now I am unable to login using the query browser in my system. I am getting another error when I try to login using the query browser from my system.
The error I am getting when I try to login using the query browser from my system is this --> "Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)". How can I solve this error?
mysql
mysql
edited May 5 '16 at 14:29
Rick James
43.8k22259
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
edited May 5 '16 at 14:29
Rick James
43.8k22259
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
edited May 5 '16 at 14:29
Rick James
43.8k22259
edited May 5 '16 at 14:29
Rick James
43.8k22259
edited May 5 '16 at 14:29
Rick James
43.8k22259
43.8k22259
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
asked May 5 '16 at 6:16
Ramkumar SRamkumar S
154
154
bumped to the homepage by Community♦ 23 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 23 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Please send the output of below queries:select user,host from mysql.user;andshow grants for root@'%';
– Geetanjali
May 5 '16 at 12:28
1
Possible duplicate of How to securely connect app and database servers?
– hot2use
Oct 6 '17 at 21:21
@Geetanjali that does seem like a leak of personal information. I would probably just suggest how the asker could use that information to tell how that would be helpful for diagnosis
– jcolebrand♦
Jul 29 '18 at 23:41
add a comment |
Please send the output of below queries:select user,host from mysql.user;andshow grants for root@'%';
– Geetanjali
May 5 '16 at 12:28
1
Possible duplicate of How to securely connect app and database servers?
– hot2use
Oct 6 '17 at 21:21
@Geetanjali that does seem like a leak of personal information. I would probably just suggest how the asker could use that information to tell how that would be helpful for diagnosis
– jcolebrand♦
Jul 29 '18 at 23:41
Please send the output of below queries:
select user,host from mysql.user; and show grants for root@'%';– Geetanjali
May 5 '16 at 12:28
Please send the output of below queries:
select user,host from mysql.user; and show grants for root@'%';– Geetanjali
May 5 '16 at 12:28
1
1
Possible duplicate of How to securely connect app and database servers?
– hot2use
Oct 6 '17 at 21:21
Possible duplicate of How to securely connect app and database servers?
– hot2use
Oct 6 '17 at 21:21
@Geetanjali that does seem like a leak of personal information. I would probably just suggest how the asker could use that information to tell how that would be helpful for diagnosis
– jcolebrand♦
Jul 29 '18 at 23:41
@Geetanjali that does seem like a leak of personal information. I would probably just suggest how the asker could use that information to tell how that would be helpful for diagnosis
– jcolebrand♦
Jul 29 '18 at 23:41
add a comment |
1 Answer
1
active
oldest
votes
1) 'my public ip' is this ip allowed to connect your mysql server?
note : i know you have allowed from everywhere '%' but better to check again, whether your server ('my public ip') is allowed to connect to mysql server
2) If 1st is ok then please check your password. Looks like something wrong with the password (typo, or copy issue etc).
Hope this helps.
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f137600%2fcould-not-connect-to-the-specific-instance-mysql-error-number-1045-access-deni%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
1) 'my public ip' is this ip allowed to connect your mysql server?
note : i know you have allowed from everywhere '%' but better to check again, whether your server ('my public ip') is allowed to connect to mysql server
2) If 1st is ok then please check your password. Looks like something wrong with the password (typo, or copy issue etc).
Hope this helps.
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
add a comment |
1) 'my public ip' is this ip allowed to connect your mysql server?
note : i know you have allowed from everywhere '%' but better to check again, whether your server ('my public ip') is allowed to connect to mysql server
2) If 1st is ok then please check your password. Looks like something wrong with the password (typo, or copy issue etc).
Hope this helps.
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
add a comment |
1) 'my public ip' is this ip allowed to connect your mysql server?
note : i know you have allowed from everywhere '%' but better to check again, whether your server ('my public ip') is allowed to connect to mysql server
2) If 1st is ok then please check your password. Looks like something wrong with the password (typo, or copy issue etc).
Hope this helps.
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
1) 'my public ip' is this ip allowed to connect your mysql server?
note : i know you have allowed from everywhere '%' but better to check again, whether your server ('my public ip') is allowed to connect to mysql server
2) If 1st is ok then please check your password. Looks like something wrong with the password (typo, or copy issue etc).
Hope this helps.
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
edited Apr 10 '17 at 19:43
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
answered Apr 9 '17 at 12:05
VaibhavVaibhav
316
316
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f137600%2fcould-not-connect-to-the-specific-instance-mysql-error-number-1045-access-deni%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
Please send the output of below queries:
select user,host from mysql.user;andshow grants for root@'%';– Geetanjali
May 5 '16 at 12:28
1
Possible duplicate of How to securely connect app and database servers?
– hot2use
Oct 6 '17 at 21:21
@Geetanjali that does seem like a leak of personal information. I would probably just suggest how the asker could use that information to tell how that would be helpful for diagnosis
– jcolebrand♦
Jul 29 '18 at 23:41