Connect to MySQL in javascript server side without node.js - Stack Overflow

admin管理员组

文章数量:1026192

I have a javascript application running with server like nginx or eclipse local server, and i would like to know if it is possible to connect it with mysql server database.

I know that they are a lot of npm packages for nodejs application, but i don't want to use node js because if i'll do that i have to implement all structure of nodejs application with all dependencies and i don't know very well this technology to do that.

Thanks.

I have a javascript application running with server like nginx or eclipse local server, and i would like to know if it is possible to connect it with mysql server database.

I know that they are a lot of npm packages for nodejs application, but i don't want to use node js because if i'll do that i have to implement all structure of nodejs application with all dependencies and i don't know very well this technology to do that.

Thanks.

• javascript
• mysql
• nginx

Share Improve this question Follow edited Dec 29, 2015 at 17:07 CodeWizard 143k2222 gold badges160160 silver badges180180 bronze badges asked Dec 29, 2015 at 17:06 shmoolkishmoolki 1,56199 gold badges3535 silver badges5858 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 5

There is no way to connect to a remote database server directly from JavaScript running in a browser… and if there was it would probably involve a huge security hole since anyone with access to the client could take your credentials and run any SQL they like on the server. It is unlikely you could make your database GRANTS fine-grained enough for public consumption.

If you want your client side JS to interact with your database server then you need to write a webservice for it. You can do that in Node.JS or any other server side environment you like.

If you are using Node.JS then you will probably want Nginx to proxy the requests.

Nginx supports FastCGI so you could write in any language that supports FastCGI such as Perl or PHP.

I have a javascript application running with server like nginx or eclipse local server, and i would like to know if it is possible to connect it with mysql server database.

I know that they are a lot of npm packages for nodejs application, but i don't want to use node js because if i'll do that i have to implement all structure of nodejs application with all dependencies and i don't know very well this technology to do that.

Thanks.

I have a javascript application running with server like nginx or eclipse local server, and i would like to know if it is possible to connect it with mysql server database.

I know that they are a lot of npm packages for nodejs application, but i don't want to use node js because if i'll do that i have to implement all structure of nodejs application with all dependencies and i don't know very well this technology to do that.

Thanks.

• javascript
• mysql
• nginx

Share Improve this question Follow edited Dec 29, 2015 at 17:07 CodeWizard 143k2222 gold badges160160 silver badges180180 bronze badges asked Dec 29, 2015 at 17:06 shmoolkishmoolki 1,56199 gold badges3535 silver badges5858 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 5

There is no way to connect to a remote database server directly from JavaScript running in a browser… and if there was it would probably involve a huge security hole since anyone with access to the client could take your credentials and run any SQL they like on the server. It is unlikely you could make your database GRANTS fine-grained enough for public consumption.

If you want your client side JS to interact with your database server then you need to write a webservice for it. You can do that in Node.JS or any other server side environment you like.

If you are using Node.JS then you will probably want Nginx to proxy the requests.

Nginx supports FastCGI so you could write in any language that supports FastCGI such as Perl or PHP.

本文标签： Connect to MySQL in javascript server side without nodejsStack Overflow