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
I guess this may be caused by a username...
Have you encountered a similar problem?
mysql mysql-workbench navicat
New contributor
add a comment |
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
I guess this may be caused by a username...
Have you encountered a similar problem?
mysql mysql-workbench navicat
New contributor
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
add a comment |
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
I guess this may be caused by a username...
Have you encountered a similar problem?
mysql mysql-workbench navicat
New contributor
Just like title,I can login by mysql-navicat.
But when I used mysql-workbench, it says Access Denied
I guess this may be caused by a username...
Have you encountered a similar problem?
mysql mysql-workbench navicat
mysql mysql-workbench navicat
New contributor
New contributor
edited Nov 21 at 13:49
ADyson
21.9k112443
21.9k112443
New contributor
asked Nov 21 at 13:44
王瑞环
242
242
New contributor
New contributor
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
add a comment |
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
add a comment |
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..
New contributor
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
add a comment |
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..
New contributor
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
add a comment |
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..
New contributor
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
add a comment |
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..
New contributor
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..
New contributor
edited Nov 22 at 3:17
New contributor
answered Nov 22 at 3:10
王瑞环
242
242
New contributor
New contributor
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
add a comment |
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
add a comment |
王瑞环 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.
王瑞环 is a new contributor. Be nice, and check out our Code of Conduct.
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%2f53413459%2funable-to-login-mysql-by-mysql-workbench-when-username-contains%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
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