{"id":41004,"date":"2024-05-13T11:05:05","date_gmt":"2024-05-13T11:05:05","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=41004"},"modified":"2026-02-19T05:47:00","modified_gmt":"2026-02-19T05:47:00","slug":"nodejs-connection-to-mysql-mariadb","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/nodejs-connection-to-mysql-mariadb","title":{"rendered":"How to Connect a Node.js Application with MySQL\/MariaDB\/Percona?"},"content":{"rendered":"

How to Connect a Node.js Application with MySQL\/MariaDB\/Percona?<\/h2>\n

MySQL, MariaDB<\/a>, and Percona stand out as some of the most widely used open-source SQL databases, trusted by some of the world’s largest organizations. This guide will provide a straightforward example demonstrating how to establish a connection between a Node.js<\/a> application and a MySQL server.<\/strong><\/p>\n

Step 1.<\/strong> Access your Platform as a Service (PaaS)<\/strong> account and set up an environment containing a MySQL database server. Additionally, include a Node.js compute node for this tutorial.<\/div>\n

\"Node.js<\/a><\/p>\n

Step 2.<\/strong> Access your NodeJS server via SSH, e.g. with an embedded Web SSH client.<\/strong><\/p>\n

\"Web<\/a><\/p>\n

Step 3.<\/strong> After establishing the connection, obtain an official MySQL driver<\/strong> for Node.js that is compatible with MariaDB<\/strong> by running the following command:<\/p>\n

<\/div>\n
\r\nnpm install mysql<\/code><\/pre>\n
<\/div>\n
\"Node.js<\/a><\/p>\n
Step 4.<\/strong> Create a basic Node.js script to validate the connection. Use any text editor to create a file with the .js extension (e.g., vi script.js).<\/p>\n
<\/div>\n
\r\nvar mysql = require('mysql');\r\nvar con = mysql.createConnection({\r\nhost: \"{host}\",\r\nuser: \"{user}\",\r\npassword: \"{password}\",\r\ndatabase: \"{database}\"\r\n});\r\ncon.connect(function(err) {\r\nif (err) throw err;\r\nconsole.log(\"You are connected!\");\r\n});\r\ncon.end();<\/code><\/pre>\n
<\/div>\n
The placeholders within the provided code should be adjusted with the relevant connection information typically provided within the email for your MySQL<\/a>\/MariaDB container.<\/p>\n