Sure, here is a README.md file for your package mb64sql-connect:

# mb64sql-connect

`mb64sql-connect` is a simple Node.js package for connecting to a MySQL database using the `mysql2` library. It simplifies the process of establishing a connection to your MySQL database and provides basic error handling.

## Installation

You can install `mb64sql-connect` via npm:

```sh
npm install mb64sql-connect

Usage

Importing the Package

First, import the package into your project:

const connectDB = require("mb64sql-connect");

Establishing a Connection

Use the connectDB function to create a connection to your MySQL database:

const connection = connectDB("host", "user", "password", "database");

Example with Express

Here's an example of how you can use mb64sql-connect in an Express application to fetch data from a MySQL database:

const express = require('express');
const connectDB = require('mb64sql-connect');

const app = express();
const connection = connectDB("host", "user", "password", "database");

app.get("/", (req, res) => {
    connection.query("SELECT * FROM students", (err, rows) => {
        if (err) {
            console.log(err);
            res.status(500).send("Error fetching data");
        } else {
            res.json(rows);
        }
    });
});

const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
    console.log(`Server is running on port ${PORT}`);
});

Error Handling

• If any of the connection parameters are missing, the function will log Connection parameters are missing and return null.
• If the connection parameters are incorrect, it will log Connection parameters are wrong followed by the error stack trace.

Example Error Handling

const connection = connectDB("", "user", "password", "database");
// Logs: Connection parameters are missing

const connection = connectDB("host", "wrong_user", "wrong_password", "database");
// Logs: Connection parameters are wrong: <error stack trace>

License

This project is licensed under the MIT License. See the LICENSE file for details.

Contributing

If you'd like to contribute, please fork the repository and use a feature branch. Pull requests are welcome.

Acknowledgements

• mysql2 - A MySQL client for Node.js

Note: Ensure your database credentials are stored securely and not hardcoded in your application in production.

This `README.md` file includes installation instructions, usage examples, error handling explanations, and other necessary information for users to get started with your `mb64sql-connect` package.