Unable to login mysql by mysql-workbench when username contains '%'











up vote
-2
down vote

favorite












Just like title,I can login by mysql-navicat.
But when I used mysql-workbench, it says Access Denied



enter image description here



I guess this may be caused by a username...



Have you encountered a similar problem?










share|improve this question









New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 1




    please share the logs in text, and the errors you get. furthermore describe the issue in detailed steps. also - do you have another user that works? can you log in through mysql-cli?
    – JoSSte
    Nov 21 at 13:48










  • It is not a good idea to have wildcard characters in usernames
    – Dave Stokes
    Nov 21 at 14:45










  • @JoSSte Yes, I can log in through mysql-cli and navicat.
    – 王瑞环
    Nov 22 at 2:06










  • @DaveStokes I think so too.But I don't have permission to create new users or change this. =.=
    – 王瑞环
    Nov 22 at 2:24










  • @JoSSte Well..This workbench is :MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit). The mysql server version is : 5.5.0.0 MySQL Community Server (GPL)
    – 王瑞环
    Nov 22 at 2:29

















up vote
-2
down vote

favorite












Just like title,I can login by mysql-navicat.
But when I used mysql-workbench, it says Access Denied



enter image description here



I guess this may be caused by a username...



Have you encountered a similar problem?










share|improve this question









New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 1




    please share the logs in text, and the errors you get. furthermore describe the issue in detailed steps. also - do you have another user that works? can you log in through mysql-cli?
    – JoSSte
    Nov 21 at 13:48










  • It is not a good idea to have wildcard characters in usernames
    – Dave Stokes
    Nov 21 at 14:45










  • @JoSSte Yes, I can log in through mysql-cli and navicat.
    – 王瑞环
    Nov 22 at 2:06










  • @DaveStokes I think so too.But I don't have permission to create new users or change this. =.=
    – 王瑞环
    Nov 22 at 2:24










  • @JoSSte Well..This workbench is :MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit). The mysql server version is : 5.5.0.0 MySQL Community Server (GPL)
    – 王瑞环
    Nov 22 at 2:29















up vote
-2
down vote

favorite









up vote
-2
down vote

favorite











Just like title,I can login by mysql-navicat.
But when I used mysql-workbench, it says Access Denied



enter image description here



I guess this may be caused by a username...



Have you encountered a similar problem?










share|improve this question









New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











Just like title,I can login by mysql-navicat.
But when I used mysql-workbench, it says Access Denied



enter image description here



I guess this may be caused by a username...



Have you encountered a similar problem?







mysql mysql-workbench navicat






share|improve this question









New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited Nov 21 at 13:49









ADyson

21.9k112443




21.9k112443






New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Nov 21 at 13:44









王瑞环

242




242




New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 1




    please share the logs in text, and the errors you get. furthermore describe the issue in detailed steps. also - do you have another user that works? can you log in through mysql-cli?
    – JoSSte
    Nov 21 at 13:48










  • It is not a good idea to have wildcard characters in usernames
    – Dave Stokes
    Nov 21 at 14:45










  • @JoSSte Yes, I can log in through mysql-cli and navicat.
    – 王瑞环
    Nov 22 at 2:06










  • @DaveStokes I think so too.But I don't have permission to create new users or change this. =.=
    – 王瑞环
    Nov 22 at 2:24










  • @JoSSte Well..This workbench is :MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit). The mysql server version is : 5.5.0.0 MySQL Community Server (GPL)
    – 王瑞环
    Nov 22 at 2:29
















  • 1




    please share the logs in text, and the errors you get. furthermore describe the issue in detailed steps. also - do you have another user that works? can you log in through mysql-cli?
    – JoSSte
    Nov 21 at 13:48










  • It is not a good idea to have wildcard characters in usernames
    – Dave Stokes
    Nov 21 at 14:45










  • @JoSSte Yes, I can log in through mysql-cli and navicat.
    – 王瑞环
    Nov 22 at 2:06










  • @DaveStokes I think so too.But I don't have permission to create new users or change this. =.=
    – 王瑞环
    Nov 22 at 2:24










  • @JoSSte Well..This workbench is :MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit). The mysql server version is : 5.5.0.0 MySQL Community Server (GPL)
    – 王瑞环
    Nov 22 at 2:29










1




1




please share the logs in text, and the errors you get. furthermore describe the issue in detailed steps. also - do you have another user that works? can you log in through mysql-cli?
– JoSSte
Nov 21 at 13:48




please share the logs in text, and the errors you get. furthermore describe the issue in detailed steps. also - do you have another user that works? can you log in through mysql-cli?
– JoSSte
Nov 21 at 13:48












It is not a good idea to have wildcard characters in usernames
– Dave Stokes
Nov 21 at 14:45




It is not a good idea to have wildcard characters in usernames
– Dave Stokes
Nov 21 at 14:45












@JoSSte Yes, I can log in through mysql-cli and navicat.
– 王瑞环
Nov 22 at 2:06




@JoSSte Yes, I can log in through mysql-cli and navicat.
– 王瑞环
Nov 22 at 2:06












@DaveStokes I think so too.But I don't have permission to create new users or change this. =.=
– 王瑞环
Nov 22 at 2:24




@DaveStokes I think so too.But I don't have permission to create new users or change this. =.=
– 王瑞环
Nov 22 at 2:24












@JoSSte Well..This workbench is :MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit). The mysql server version is : 5.5.0.0 MySQL Community Server (GPL)
– 王瑞环
Nov 22 at 2:29






@JoSSte Well..This workbench is :MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit). The mysql server version is : 5.5.0.0 MySQL Community Server (GPL)
– 王瑞环
Nov 22 at 2:29














1 Answer
1






active

oldest

votes

















up vote
0
down vote













Well..
Server version: 5.5.0.0 MySQL Community Server (GPL).



The version of the workbench I used before was MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit).



Now I install the MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit).



It can work.
Maybe the 8.0 workbench replaced the wildcard in the username..






share|improve this answer










New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.


















  • If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
    – JoSSte
    Nov 22 at 4:55










  • @JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
    – 王瑞环
    Nov 22 at 6:20










  • Well done. Congratulations
    – JoSSte
    Nov 22 at 7:44











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',
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
});


}
});






王瑞环 is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413459%2funable-to-login-mysql-by-mysql-workbench-when-username-contains%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








up vote
0
down vote













Well..
Server version: 5.5.0.0 MySQL Community Server (GPL).



The version of the workbench I used before was MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit).



Now I install the MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit).



It can work.
Maybe the 8.0 workbench replaced the wildcard in the username..






share|improve this answer










New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.


















  • If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
    – JoSSte
    Nov 22 at 4:55










  • @JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
    – 王瑞环
    Nov 22 at 6:20










  • Well done. Congratulations
    – JoSSte
    Nov 22 at 7:44















up vote
0
down vote













Well..
Server version: 5.5.0.0 MySQL Community Server (GPL).



The version of the workbench I used before was MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit).



Now I install the MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit).



It can work.
Maybe the 8.0 workbench replaced the wildcard in the username..






share|improve this answer










New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.


















  • If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
    – JoSSte
    Nov 22 at 4:55










  • @JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
    – 王瑞环
    Nov 22 at 6:20










  • Well done. Congratulations
    – JoSSte
    Nov 22 at 7:44













up vote
0
down vote










up vote
0
down vote









Well..
Server version: 5.5.0.0 MySQL Community Server (GPL).



The version of the workbench I used before was MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit).



Now I install the MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit).



It can work.
Maybe the 8.0 workbench replaced the wildcard in the username..






share|improve this answer










New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









Well..
Server version: 5.5.0.0 MySQL Community Server (GPL).



The version of the workbench I used before was MySQL Workbench Community (GPL) for Linux/Unix version 8.0.13 CE build 13780177 (64 bit).



Now I install the MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit).



It can work.
Maybe the 8.0 workbench replaced the wildcard in the username..







share|improve this answer










New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this answer



share|improve this answer








edited Nov 22 at 3:17





















New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









answered Nov 22 at 3:10









王瑞环

242




242




New contributor




王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






王瑞环 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












  • If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
    – JoSSte
    Nov 22 at 4:55










  • @JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
    – 王瑞环
    Nov 22 at 6:20










  • Well done. Congratulations
    – JoSSte
    Nov 22 at 7:44


















  • If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
    – JoSSte
    Nov 22 at 4:55










  • @JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
    – 王瑞环
    Nov 22 at 6:20










  • Well done. Congratulations
    – JoSSte
    Nov 22 at 7:44
















If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
– JoSSte
Nov 22 at 4:55




If this is just comments to your original question n, edit the question. Answer posts should contain... Answers
– JoSSte
Nov 22 at 4:55












@JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
– 王瑞环
Nov 22 at 6:20




@JoSSte It's the answer...I fix this problem by installing the low version of the workbench.Thanks for your help.
– 王瑞环
Nov 22 at 6:20












Well done. Congratulations
– JoSSte
Nov 22 at 7:44




Well done. Congratulations
– JoSSte
Nov 22 at 7:44










王瑞环 is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















王瑞环 is a new contributor. Be nice, and check out our Code of Conduct.













王瑞环 is a new contributor. Be nice, and check out our Code of Conduct.












王瑞环 is a new contributor. Be nice, and check out our Code of Conduct.















 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413459%2funable-to-login-mysql-by-mysql-workbench-when-username-contains%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

Contact image not getting when fetch all contact list from iPhone by CNContact

count number of partitions of a set with n elements into k subsets

A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks