Why can't I query table in MySQLWorkbench?
Multi tool use
up vote
0
down vote
favorite
I have a NodeJS app that uses MySQL. When I open the MySQLWorkbench and select the table the app uses, then click the icon to query the first 1000 rows, it gets stuck (spinning icon) and never shows any results. I can't stop it either. I have to force quit the Workbench.
Any idea why this happens?
node.js macos mysql-workbench
asked Nov 10 at 19:36
4thSpace
18.2k77218393
|
show 2 more comments
up vote
0
down vote
favorite
I have a NodeJS app that uses MySQL. When I open the MySQLWorkbench and select the table the app uses, then click the icon to query the first 1000 rows, it gets stuck (spinning icon) and never shows any results. I can't stop it either. I have to force quit the Workbench.
Any idea why this happens?
node.js macos mysql-workbench
asked Nov 10 at 19:36
4thSpace
18.2k77218393
This problem has nothing to do with Node.js. Does WB also hang when you query a different schema or even a different server? What does the WB log say? Any hints there if something is wrong?
– Mike Lischke
Nov 11 at 10:06
I see this when I click "Server logs": Location of MySQL configuration file (ie: my.cnf) not specified. Although the I clearly have a path to /usr/local/mysql/logs/my.cnf set for Configuration File.
– 4thSpace
Nov 11 at 14:46
Have you set this path in the connection settings? Otherwise WB cannot find it. Also: I didn't ask for the server logs, but the WB log (seeHelp -> Locate Log Files.
– Mike Lischke
Nov 12 at 7:39
Where do I set that path in the connection settings? Also, why would a connection string contain a log file path?
– 4thSpace
Nov 12 at 15:10
I didn't say you have to set a log file path. My reply was for your claim that you set the path to your config file and I asked if that happened in the connection settings (seeconnection editor -> System Profile tab -> Configuration File:).
– Mike Lischke
Nov 12 at 15:15
|
show 2 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a NodeJS app that uses MySQL. When I open the MySQLWorkbench and select the table the app uses, then click the icon to query the first 1000 rows, it gets stuck (spinning icon) and never shows any results. I can't stop it either. I have to force quit the Workbench.
Any idea why this happens?
node.js macos mysql-workbench
asked Nov 10 at 19:36
4thSpace
18.2k77218393
I have a NodeJS app that uses MySQL. When I open the MySQLWorkbench and select the table the app uses, then click the icon to query the first 1000 rows, it gets stuck (spinning icon) and never shows any results. I can't stop it either. I have to force quit the Workbench.
Any idea why this happens?
node.js macos mysql-workbench
node.js macos mysql-workbench
asked Nov 10 at 19:36
4thSpace
18.2k77218393
asked Nov 10 at 19:36
4thSpace
18.2k77218393
asked Nov 10 at 19:36
4thSpace
18.2k77218393
asked Nov 10 at 19:36
4thSpace
18.2k77218393
asked Nov 10 at 19:36
4thSpace
18.2k77218393
18.2k77218393
This problem has nothing to do with Node.js. Does WB also hang when you query a different schema or even a different server? What does the WB log say? Any hints there if something is wrong?
– Mike Lischke
Nov 11 at 10:06
I see this when I click "Server logs": Location of MySQL configuration file (ie: my.cnf) not specified. Although the I clearly have a path to /usr/local/mysql/logs/my.cnf set for Configuration File.
– 4thSpace
Nov 11 at 14:46
Have you set this path in the connection settings? Otherwise WB cannot find it. Also: I didn't ask for the server logs, but the WB log (seeHelp -> Locate Log Files.
– Mike Lischke
Nov 12 at 7:39
Where do I set that path in the connection settings? Also, why would a connection string contain a log file path?
– 4thSpace
Nov 12 at 15:10
I didn't say you have to set a log file path. My reply was for your claim that you set the path to your config file and I asked if that happened in the connection settings (seeconnection editor -> System Profile tab -> Configuration File:).
– Mike Lischke
Nov 12 at 15:15
|
show 2 more comments
This problem has nothing to do with Node.js. Does WB also hang when you query a different schema or even a different server? What does the WB log say? Any hints there if something is wrong?
– Mike Lischke
Nov 11 at 10:06
I see this when I click "Server logs": Location of MySQL configuration file (ie: my.cnf) not specified. Although the I clearly have a path to /usr/local/mysql/logs/my.cnf set for Configuration File.
– 4thSpace
Nov 11 at 14:46
Have you set this path in the connection settings? Otherwise WB cannot find it. Also: I didn't ask for the server logs, but the WB log (seeHelp -> Locate Log Files.
– Mike Lischke
Nov 12 at 7:39
Where do I set that path in the connection settings? Also, why would a connection string contain a log file path?
– 4thSpace
Nov 12 at 15:10
I didn't say you have to set a log file path. My reply was for your claim that you set the path to your config file and I asked if that happened in the connection settings (seeconnection editor -> System Profile tab -> Configuration File:).
– Mike Lischke
Nov 12 at 15:15
This problem has nothing to do with Node.js. Does WB also hang when you query a different schema or even a different server? What does the WB log say? Any hints there if something is wrong?
– Mike Lischke
Nov 11 at 10:06
This problem has nothing to do with Node.js. Does WB also hang when you query a different schema or even a different server? What does the WB log say? Any hints there if something is wrong?
– Mike Lischke
Nov 11 at 10:06
I see this when I click "Server logs": Location of MySQL configuration file (ie: my.cnf) not specified. Although the I clearly have a path to /usr/local/mysql/logs/my.cnf set for Configuration File.
– 4thSpace
Nov 11 at 14:46
I see this when I click "Server logs": Location of MySQL configuration file (ie: my.cnf) not specified. Although the I clearly have a path to /usr/local/mysql/logs/my.cnf set for Configuration File.
– 4thSpace
Nov 11 at 14:46
Have you set this path in the connection settings? Otherwise WB cannot find it. Also: I didn't ask for the server logs, but the WB log (see
Help -> Locate Log Files.– Mike Lischke
Nov 12 at 7:39
Have you set this path in the connection settings? Otherwise WB cannot find it. Also: I didn't ask for the server logs, but the WB log (see
Help -> Locate Log Files.– Mike Lischke
Nov 12 at 7:39
Where do I set that path in the connection settings? Also, why would a connection string contain a log file path?
– 4thSpace
Nov 12 at 15:10
Where do I set that path in the connection settings? Also, why would a connection string contain a log file path?
– 4thSpace
Nov 12 at 15:10
I didn't say you have to set a log file path. My reply was for your claim that you set the path to your config file and I asked if that happened in the connection settings (see
connection editor -> System Profile tab -> Configuration File:).– Mike Lischke
Nov 12 at 15:15
I didn't say you have to set a log file path. My reply was for your claim that you set the path to your config file and I asked if that happened in the connection settings (see
connection editor -> System Profile tab -> Configuration File:).– Mike Lischke
Nov 12 at 15:15
|
show 2 more comments
active
oldest
votes
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
);
);
draft saved
draft discarded
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%2f53242703%2fwhy-cant-i-query-table-in-mysqlworkbench%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f53242703%2fwhy-cant-i-query-table-in-mysqlworkbench%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
p7Bva0
This problem has nothing to do with Node.js. Does WB also hang when you query a different schema or even a different server? What does the WB log say? Any hints there if something is wrong?
– Mike Lischke
Nov 11 at 10:06
I see this when I click "Server logs": Location of MySQL configuration file (ie: my.cnf) not specified. Although the I clearly have a path to /usr/local/mysql/logs/my.cnf set for Configuration File.
– 4thSpace
Nov 11 at 14:46
Have you set this path in the connection settings? Otherwise WB cannot find it. Also: I didn't ask for the server logs, but the WB log (see
Help -> Locate Log Files.– Mike Lischke
Nov 12 at 7:39
Where do I set that path in the connection settings? Also, why would a connection string contain a log file path?
– 4thSpace
Nov 12 at 15:10
I didn't say you have to set a log file path. My reply was for your claim that you set the path to your config file and I asked if that happened in the connection settings (see
connection editor -> System Profile tab -> Configuration File:).– Mike Lischke
Nov 12 at 15:15