How do I create a mySQL database to integrate with nodeJS on visual studio 2017 community?












0















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.










share|improve this question

























  • 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











  • 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
















0















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.










share|improve this question

























  • 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











  • 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














0












0








0








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.










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 25 '18 at 20:30







Gabriel Reyes

















asked Nov 25 '18 at 19:27









Gabriel ReyesGabriel Reyes

173




173













  • 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











  • 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











  • @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












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


}
});














draft saved

draft discarded


















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
















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.




draft saved


draft discarded














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





















































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

404 Error Contact Form 7 ajax form submitting

How to know if a Active Directory user can login interactively

TypeError: fit_transform() missing 1 required positional argument: 'X'