MySql WorkBench Can't connect to MySQL server on '127.0.0.1' (111)
I have install mysql Workbench using ubuntu software center, now i want to create a connection but facing this problem.
mysql mysql-workbench
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
add a comment |
I have install mysql Workbench using ubuntu software center, now i want to create a connection but facing this problem.
mysql mysql-workbench
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
Try the answers in this url : stackoverflow.com/questions/1420839/…
– Haitham A. El-Ghareeb
Apr 7 '17 at 18:55
I have not created a linux sql server , i have installed Mysql Workbench
– Waqar Ahmad Khan
Apr 8 '17 at 9:29
add a comment |
I have install mysql Workbench using ubuntu software center, now i want to create a connection but facing this problem.
mysql mysql-workbench
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
I have install mysql Workbench using ubuntu software center, now i want to create a connection but facing this problem.
mysql mysql-workbench
mysql mysql-workbench
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
asked Apr 7 '17 at 16:51
Waqar Ahmad KhanWaqar Ahmad Khan
1115
1115
Try the answers in this url : stackoverflow.com/questions/1420839/…
– Haitham A. El-Ghareeb
Apr 7 '17 at 18:55
I have not created a linux sql server , i have installed Mysql Workbench
– Waqar Ahmad Khan
Apr 8 '17 at 9:29
add a comment |
Try the answers in this url : stackoverflow.com/questions/1420839/…
– Haitham A. El-Ghareeb
Apr 7 '17 at 18:55
I have not created a linux sql server , i have installed Mysql Workbench
– Waqar Ahmad Khan
Apr 8 '17 at 9:29
Try the answers in this url : stackoverflow.com/questions/1420839/…
– Haitham A. El-Ghareeb
Apr 7 '17 at 18:55
Try the answers in this url : stackoverflow.com/questions/1420839/…
– Haitham A. El-Ghareeb
Apr 7 '17 at 18:55
I have not created a linux sql server , i have installed Mysql Workbench
– Waqar Ahmad Khan
Apr 8 '17 at 9:29
I have not created a linux sql server , i have installed Mysql Workbench
– Waqar Ahmad Khan
Apr 8 '17 at 9:29
add a comment |
3 Answers
3
active
oldest
votes
Ok, This means that you need to install MySQL first, or connect to a machine with MySQL installed. Check this URL on how to do so on Ubuntu
https://www.linode.com/docs/databases/mysql/install-mysql-on-ubuntu-14-04
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
add a comment |
I faced this problem once. The issue was that the allowed host for root was localhost. The host was not unable to map localhost to 127.0.0.1. In your my.cnf file, set the bind address as follows:
bind-address = 127.0.0.1
To allow all IPs use %.
Restart the server and then check.
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
add a comment |
same issue i faced with mysql workbench 6.3.8 build 1228 CE (64-bits) community with kubuntu 18.04 version.
i set connection method standard tcp/ip over ssh and when i try to connect to remote server it asks for ssh password and after successful ssh tunnel it asks for remote mysql password ( which was expected as i did not store passwords in keychain -- option available there in connection window ) and when i entered it i got same above error.
after checking at server mysql log i found this line:
Access denied for user 'root'@'localhost' (using password: NO)
but i already entered the password while workbench asks me.
finally i try edit connection and store mysql password there in keychain option and it works fine.
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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%2faskubuntu.com%2fquestions%2f901266%2fmysql-workbench-cant-connect-to-mysql-server-on-127-0-0-1-111%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Ok, This means that you need to install MySQL first, or connect to a machine with MySQL installed. Check this URL on how to do so on Ubuntu
https://www.linode.com/docs/databases/mysql/install-mysql-on-ubuntu-14-04
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
add a comment |
Ok, This means that you need to install MySQL first, or connect to a machine with MySQL installed. Check this URL on how to do so on Ubuntu
https://www.linode.com/docs/databases/mysql/install-mysql-on-ubuntu-14-04
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
add a comment |
Ok, This means that you need to install MySQL first, or connect to a machine with MySQL installed. Check this URL on how to do so on Ubuntu
https://www.linode.com/docs/databases/mysql/install-mysql-on-ubuntu-14-04
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
Ok, This means that you need to install MySQL first, or connect to a machine with MySQL installed. Check this URL on how to do so on Ubuntu
https://www.linode.com/docs/databases/mysql/install-mysql-on-ubuntu-14-04
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
answered Apr 8 '17 at 11:27
Haitham A. El-GhareebHaitham A. El-Ghareeb
16718
16718
add a comment |
add a comment |
I faced this problem once. The issue was that the allowed host for root was localhost. The host was not unable to map localhost to 127.0.0.1. In your my.cnf file, set the bind address as follows:
bind-address = 127.0.0.1
To allow all IPs use %.
Restart the server and then check.
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
add a comment |
I faced this problem once. The issue was that the allowed host for root was localhost. The host was not unable to map localhost to 127.0.0.1. In your my.cnf file, set the bind address as follows:
bind-address = 127.0.0.1
To allow all IPs use %.
Restart the server and then check.
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
add a comment |
I faced this problem once. The issue was that the allowed host for root was localhost. The host was not unable to map localhost to 127.0.0.1. In your my.cnf file, set the bind address as follows:
bind-address = 127.0.0.1
To allow all IPs use %.
Restart the server and then check.
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
I faced this problem once. The issue was that the allowed host for root was localhost. The host was not unable to map localhost to 127.0.0.1. In your my.cnf file, set the bind address as follows:
bind-address = 127.0.0.1
To allow all IPs use %.
Restart the server and then check.
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
answered Apr 8 '17 at 13:39
Noisy_BotnetNoisy_Botnet
1,083312
1,083312
add a comment |
add a comment |
same issue i faced with mysql workbench 6.3.8 build 1228 CE (64-bits) community with kubuntu 18.04 version.
i set connection method standard tcp/ip over ssh and when i try to connect to remote server it asks for ssh password and after successful ssh tunnel it asks for remote mysql password ( which was expected as i did not store passwords in keychain -- option available there in connection window ) and when i entered it i got same above error.
after checking at server mysql log i found this line:
Access denied for user 'root'@'localhost' (using password: NO)
but i already entered the password while workbench asks me.
finally i try edit connection and store mysql password there in keychain option and it works fine.
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
add a comment |
same issue i faced with mysql workbench 6.3.8 build 1228 CE (64-bits) community with kubuntu 18.04 version.
i set connection method standard tcp/ip over ssh and when i try to connect to remote server it asks for ssh password and after successful ssh tunnel it asks for remote mysql password ( which was expected as i did not store passwords in keychain -- option available there in connection window ) and when i entered it i got same above error.
after checking at server mysql log i found this line:
Access denied for user 'root'@'localhost' (using password: NO)
but i already entered the password while workbench asks me.
finally i try edit connection and store mysql password there in keychain option and it works fine.
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
add a comment |
same issue i faced with mysql workbench 6.3.8 build 1228 CE (64-bits) community with kubuntu 18.04 version.
i set connection method standard tcp/ip over ssh and when i try to connect to remote server it asks for ssh password and after successful ssh tunnel it asks for remote mysql password ( which was expected as i did not store passwords in keychain -- option available there in connection window ) and when i entered it i got same above error.
after checking at server mysql log i found this line:
Access denied for user 'root'@'localhost' (using password: NO)
but i already entered the password while workbench asks me.
finally i try edit connection and store mysql password there in keychain option and it works fine.
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
same issue i faced with mysql workbench 6.3.8 build 1228 CE (64-bits) community with kubuntu 18.04 version.
i set connection method standard tcp/ip over ssh and when i try to connect to remote server it asks for ssh password and after successful ssh tunnel it asks for remote mysql password ( which was expected as i did not store passwords in keychain -- option available there in connection window ) and when i entered it i got same above error.
after checking at server mysql log i found this line:
Access denied for user 'root'@'localhost' (using password: NO)
but i already entered the password while workbench asks me.
finally i try edit connection and store mysql password there in keychain option and it works fine.
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
answered Dec 28 '18 at 13:37
Suraj InamdarSuraj Inamdar
112
112
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- 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%2faskubuntu.com%2fquestions%2f901266%2fmysql-workbench-cant-connect-to-mysql-server-on-127-0-0-1-111%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
Try the answers in this url : stackoverflow.com/questions/1420839/…
– Haitham A. El-Ghareeb
Apr 7 '17 at 18:55
I have not created a linux sql server , i have installed Mysql Workbench
– Waqar Ahmad Khan
Apr 8 '17 at 9:29