javascript - How do I connect to the mysql server from the html page upon button click?

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65546431/how-do-i-connect-to-the-mysql-server-from-the-html-page-upon-button-click

Answer 1

require doesn't exist on the client (at least not natively). The code you have is meant to be run on the server (node.js).

Try putting this into a file, say main.js, and then run node main.js.

var mysql = require('mysql');

var con = mysql.createConnection({
    host: "localhost",
    user: "yourusername",
    password: "yourpassword"
});

con.connect(function(err) {
    if (err) throw err;
    console.log("Connected!");
});