How do I create a mySQL database to integrate with nodeJS on visual studio 2017 community?
The only progress I ever made on using my installation on VS was creating an sql file which doesn't help starting up a mySQL service from command line, which is exactly what I need right now. Given, the reputable sql book i learned from set up consists of launching the program from command line and creating tables in that fashion.
I only learned how to work with SQL on linux and it works flawlessly.
However I'm switching back to Windows. I have installed the necessary SQL packages yet I can't figure out how to set up my NodeJS HTTP server project to communicate with SQL.
I can't start the service on services.msc. And xaamp mySQL service isn't working either. I might even have lots of conflicting installations.
However, I'm asking about Visual Studio specifically. It gave me the option to install SQL packages during setup so I'm assuming I should be able to use it without paying Azure $200. That is, the online documentation which points me to Azure which my particular account doesn't seem to support from the online interface.
And VS is generally easy to set up. The only project I can create pertaining sql deals with sql files which I'm not to sure how to use and has no correlation with logging into a use and creating databases from command line as I'm used to with linux terminal.
mysql node.js visual-studio
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
|
show 1 more comment
The only progress I ever made on using my installation on VS was creating an sql file which doesn't help starting up a mySQL service from command line, which is exactly what I need right now. Given, the reputable sql book i learned from set up consists of launching the program from command line and creating tables in that fashion.
I only learned how to work with SQL on linux and it works flawlessly.
However I'm switching back to Windows. I have installed the necessary SQL packages yet I can't figure out how to set up my NodeJS HTTP server project to communicate with SQL.
I can't start the service on services.msc. And xaamp mySQL service isn't working either. I might even have lots of conflicting installations.
However, I'm asking about Visual Studio specifically. It gave me the option to install SQL packages during setup so I'm assuming I should be able to use it without paying Azure $200. That is, the online documentation which points me to Azure which my particular account doesn't seem to support from the online interface.
And VS is generally easy to set up. The only project I can create pertaining sql deals with sql files which I'm not to sure how to use and has no correlation with logging into a use and creating databases from command line as I'm used to with linux terminal.
mysql node.js visual-studio
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
Have you tried and failed to use themysqlpackage in npm? See this npmjs.com/package/mysql . If you're hoping to run your node server behind IIS, you might investigate this. github.com/Azure/iisnode
– O. Jones
Nov 25 '18 at 20:14
@O.Jones That's right I can't even log in to a database using node API calls. The service isn't even running on my machine. If Visual Studio offers any command line based functionality to start a mySQL service I am not aware of that. I'm still looking into getting XAAMP built in mySQL service to work, which so far has no success. Then I also downloaded standalone third party SQL and added it to my path, had no success starting up the service. I was hoping Visual Studio SQL installation. However I don't know how to work with Visual studio aside from creating projects and writing some code.
– Gabriel Reyes
Nov 25 '18 at 20:26
Which service isn't running? The MySQL service? If it isn't running you have to install either the MySQL or MariaDB server install kit. (search for Install MySQL on Windows). If you install that kit, you'll have a working MySQL server. The stuff that comes with VS is Microsoft SQL Server. That's a different DBMS with a different dialect of SQL/
– O. Jones
Nov 25 '18 at 20:30
@O.Jones Concerning Miscrosoft SQL Server VS installation. How do i start the service? and then access the SQL interface preferably from command line. To create users, databases, etc, your usual SQL commands. As far as the IDE is concerned the only SQL functionality I have pulled out is generating an SQL file which is only used for commands. I'm fairly confident I've installed the right packages. It also looks like I have Azure installed as well, however accessing it from the website seems to indicate I need to pay for it. Yet i still have it installed on VS
– Gabriel Reyes
Nov 25 '18 at 20:34
That is, the mySQL service. As far as any built in server / data creation/ service instantiation built in within visual studio I have not tested since I just started using the IDE.
– Gabriel Reyes
Nov 25 '18 at 20:44
|
show 1 more comment
The only progress I ever made on using my installation on VS was creating an sql file which doesn't help starting up a mySQL service from command line, which is exactly what I need right now. Given, the reputable sql book i learned from set up consists of launching the program from command line and creating tables in that fashion.
I only learned how to work with SQL on linux and it works flawlessly.
However I'm switching back to Windows. I have installed the necessary SQL packages yet I can't figure out how to set up my NodeJS HTTP server project to communicate with SQL.
I can't start the service on services.msc. And xaamp mySQL service isn't working either. I might even have lots of conflicting installations.
However, I'm asking about Visual Studio specifically. It gave me the option to install SQL packages during setup so I'm assuming I should be able to use it without paying Azure $200. That is, the online documentation which points me to Azure which my particular account doesn't seem to support from the online interface.
And VS is generally easy to set up. The only project I can create pertaining sql deals with sql files which I'm not to sure how to use and has no correlation with logging into a use and creating databases from command line as I'm used to with linux terminal.
mysql node.js visual-studio
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
The only progress I ever made on using my installation on VS was creating an sql file which doesn't help starting up a mySQL service from command line, which is exactly what I need right now. Given, the reputable sql book i learned from set up consists of launching the program from command line and creating tables in that fashion.
I only learned how to work with SQL on linux and it works flawlessly.
However I'm switching back to Windows. I have installed the necessary SQL packages yet I can't figure out how to set up my NodeJS HTTP server project to communicate with SQL.
I can't start the service on services.msc. And xaamp mySQL service isn't working either. I might even have lots of conflicting installations.
However, I'm asking about Visual Studio specifically. It gave me the option to install SQL packages during setup so I'm assuming I should be able to use it without paying Azure $200. That is, the online documentation which points me to Azure which my particular account doesn't seem to support from the online interface.
And VS is generally easy to set up. The only project I can create pertaining sql deals with sql files which I'm not to sure how to use and has no correlation with logging into a use and creating databases from command line as I'm used to with linux terminal.
mysql node.js visual-studio
mysql node.js visual-studio
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
edited Nov 25 '18 at 20:30
Gabriel Reyes
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
asked Nov 25 '18 at 19:27
Gabriel ReyesGabriel Reyes
173
173
Have you tried and failed to use themysqlpackage in npm? See this npmjs.com/package/mysql . If you're hoping to run your node server behind IIS, you might investigate this. github.com/Azure/iisnode
– O. Jones
Nov 25 '18 at 20:14
@O.Jones That's right I can't even log in to a database using node API calls. The service isn't even running on my machine. If Visual Studio offers any command line based functionality to start a mySQL service I am not aware of that. I'm still looking into getting XAAMP built in mySQL service to work, which so far has no success. Then I also downloaded standalone third party SQL and added it to my path, had no success starting up the service. I was hoping Visual Studio SQL installation. However I don't know how to work with Visual studio aside from creating projects and writing some code.
– Gabriel Reyes
Nov 25 '18 at 20:26
Which service isn't running? The MySQL service? If it isn't running you have to install either the MySQL or MariaDB server install kit. (search for Install MySQL on Windows). If you install that kit, you'll have a working MySQL server. The stuff that comes with VS is Microsoft SQL Server. That's a different DBMS with a different dialect of SQL/
– O. Jones
Nov 25 '18 at 20:30
@O.Jones Concerning Miscrosoft SQL Server VS installation. How do i start the service? and then access the SQL interface preferably from command line. To create users, databases, etc, your usual SQL commands. As far as the IDE is concerned the only SQL functionality I have pulled out is generating an SQL file which is only used for commands. I'm fairly confident I've installed the right packages. It also looks like I have Azure installed as well, however accessing it from the website seems to indicate I need to pay for it. Yet i still have it installed on VS
– Gabriel Reyes
Nov 25 '18 at 20:34
That is, the mySQL service. As far as any built in server / data creation/ service instantiation built in within visual studio I have not tested since I just started using the IDE.
– Gabriel Reyes
Nov 25 '18 at 20:44
|
show 1 more comment
Have you tried and failed to use themysqlpackage in npm? See this npmjs.com/package/mysql . If you're hoping to run your node server behind IIS, you might investigate this. github.com/Azure/iisnode
– O. Jones
Nov 25 '18 at 20:14
@O.Jones That's right I can't even log in to a database using node API calls. The service isn't even running on my machine. If Visual Studio offers any command line based functionality to start a mySQL service I am not aware of that. I'm still looking into getting XAAMP built in mySQL service to work, which so far has no success. Then I also downloaded standalone third party SQL and added it to my path, had no success starting up the service. I was hoping Visual Studio SQL installation. However I don't know how to work with Visual studio aside from creating projects and writing some code.
– Gabriel Reyes
Nov 25 '18 at 20:26
Which service isn't running? The MySQL service? If it isn't running you have to install either the MySQL or MariaDB server install kit. (search for Install MySQL on Windows). If you install that kit, you'll have a working MySQL server. The stuff that comes with VS is Microsoft SQL Server. That's a different DBMS with a different dialect of SQL/
– O. Jones
Nov 25 '18 at 20:30
@O.Jones Concerning Miscrosoft SQL Server VS installation. How do i start the service? and then access the SQL interface preferably from command line. To create users, databases, etc, your usual SQL commands. As far as the IDE is concerned the only SQL functionality I have pulled out is generating an SQL file which is only used for commands. I'm fairly confident I've installed the right packages. It also looks like I have Azure installed as well, however accessing it from the website seems to indicate I need to pay for it. Yet i still have it installed on VS
– Gabriel Reyes
Nov 25 '18 at 20:34
That is, the mySQL service. As far as any built in server / data creation/ service instantiation built in within visual studio I have not tested since I just started using the IDE.
– Gabriel Reyes
Nov 25 '18 at 20:44
Have you tried and failed to use the
mysql package in npm? See this npmjs.com/package/mysql . If you're hoping to run your node server behind IIS, you might investigate this. github.com/Azure/iisnode– O. Jones
Nov 25 '18 at 20:14
Have you tried and failed to use the
mysql package in npm? See this npmjs.com/package/mysql . If you're hoping to run your node server behind IIS, you might investigate this. github.com/Azure/iisnode– O. Jones
Nov 25 '18 at 20:14
@O.Jones That's right I can't even log in to a database using node API calls. The service isn't even running on my machine. If Visual Studio offers any command line based functionality to start a mySQL service I am not aware of that. I'm still looking into getting XAAMP built in mySQL service to work, which so far has no success. Then I also downloaded standalone third party SQL and added it to my path, had no success starting up the service. I was hoping Visual Studio SQL installation. However I don't know how to work with Visual studio aside from creating projects and writing some code.
– Gabriel Reyes
Nov 25 '18 at 20:26
@O.Jones That's right I can't even log in to a database using node API calls. The service isn't even running on my machine. If Visual Studio offers any command line based functionality to start a mySQL service I am not aware of that. I'm still looking into getting XAAMP built in mySQL service to work, which so far has no success. Then I also downloaded standalone third party SQL and added it to my path, had no success starting up the service. I was hoping Visual Studio SQL installation. However I don't know how to work with Visual studio aside from creating projects and writing some code.
– Gabriel Reyes
Nov 25 '18 at 20:26
Which service isn't running? The MySQL service? If it isn't running you have to install either the MySQL or MariaDB server install kit. (search for Install MySQL on Windows). If you install that kit, you'll have a working MySQL server. The stuff that comes with VS is Microsoft SQL Server. That's a different DBMS with a different dialect of SQL/
– O. Jones
Nov 25 '18 at 20:30
Which service isn't running? The MySQL service? If it isn't running you have to install either the MySQL or MariaDB server install kit. (search for Install MySQL on Windows). If you install that kit, you'll have a working MySQL server. The stuff that comes with VS is Microsoft SQL Server. That's a different DBMS with a different dialect of SQL/
– O. Jones
Nov 25 '18 at 20:30
@O.Jones Concerning Miscrosoft SQL Server VS installation. How do i start the service? and then access the SQL interface preferably from command line. To create users, databases, etc, your usual SQL commands. As far as the IDE is concerned the only SQL functionality I have pulled out is generating an SQL file which is only used for commands. I'm fairly confident I've installed the right packages. It also looks like I have Azure installed as well, however accessing it from the website seems to indicate I need to pay for it. Yet i still have it installed on VS
– Gabriel Reyes
Nov 25 '18 at 20:34
@O.Jones Concerning Miscrosoft SQL Server VS installation. How do i start the service? and then access the SQL interface preferably from command line. To create users, databases, etc, your usual SQL commands. As far as the IDE is concerned the only SQL functionality I have pulled out is generating an SQL file which is only used for commands. I'm fairly confident I've installed the right packages. It also looks like I have Azure installed as well, however accessing it from the website seems to indicate I need to pay for it. Yet i still have it installed on VS
– Gabriel Reyes
Nov 25 '18 at 20:34
That is, the mySQL service. As far as any built in server / data creation/ service instantiation built in within visual studio I have not tested since I just started using the IDE.
– Gabriel Reyes
Nov 25 '18 at 20:44
That is, the mySQL service. As far as any built in server / data creation/ service instantiation built in within visual studio I have not tested since I just started using the IDE.
– Gabriel Reyes
Nov 25 '18 at 20:44
|
show 1 more comment
0
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',
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%2fstackoverflow.com%2fquestions%2f53471066%2fhow-do-i-create-a-mysql-database-to-integrate-with-nodejs-on-visual-studio-2017%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53471066%2fhow-do-i-create-a-mysql-database-to-integrate-with-nodejs-on-visual-studio-2017%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
Have you tried and failed to use the
mysqlpackage in npm? See this npmjs.com/package/mysql . If you're hoping to run your node server behind IIS, you might investigate this. github.com/Azure/iisnode– O. Jones
Nov 25 '18 at 20:14
@O.Jones That's right I can't even log in to a database using node API calls. The service isn't even running on my machine. If Visual Studio offers any command line based functionality to start a mySQL service I am not aware of that. I'm still looking into getting XAAMP built in mySQL service to work, which so far has no success. Then I also downloaded standalone third party SQL and added it to my path, had no success starting up the service. I was hoping Visual Studio SQL installation. However I don't know how to work with Visual studio aside from creating projects and writing some code.
– Gabriel Reyes
Nov 25 '18 at 20:26
Which service isn't running? The MySQL service? If it isn't running you have to install either the MySQL or MariaDB server install kit. (search for Install MySQL on Windows). If you install that kit, you'll have a working MySQL server. The stuff that comes with VS is Microsoft SQL Server. That's a different DBMS with a different dialect of SQL/
– O. Jones
Nov 25 '18 at 20:30
@O.Jones Concerning Miscrosoft SQL Server VS installation. How do i start the service? and then access the SQL interface preferably from command line. To create users, databases, etc, your usual SQL commands. As far as the IDE is concerned the only SQL functionality I have pulled out is generating an SQL file which is only used for commands. I'm fairly confident I've installed the right packages. It also looks like I have Azure installed as well, however accessing it from the website seems to indicate I need to pay for it. Yet i still have it installed on VS
– Gabriel Reyes
Nov 25 '18 at 20:34
That is, the mySQL service. As far as any built in server / data creation/ service instantiation built in within visual studio I have not tested since I just started using the IDE.
– Gabriel Reyes
Nov 25 '18 at 20:44