I want to completely redesign my Newsletter Management System project. Please create a new version using the following technologies only, without any additional frameworks or dependencies beyond these:

Frontend: HTML, CSS, JavaScript, and Bootstrap (use the latest stable version via CDN).
Backend: Node.js and Express.js (no other frameworks or middleware except what’s necessary for basic functionality).
Database: MySQL (use the mysql2 package for database connectivity).
Please ensure the following:

Remove all existing dependencies like Next.js, React, and any related packages causing issues (e.g., legacy peer dependency conflicts).
Create a simple project structure with separate folders for public (for static files like HTML, CSS, and JS) and a server directory (for backend code).
Include basic functionality for a newsletter system, such as:
A homepage with a login/signup section.
A dashboard page (accessible after login) to manage newsletters.
User authentication (basic username/password with MySQL storage).
Ability to add and view newsletter content.
Use Bootstrap for styling to ensure a polished and responsive design.
Provide a package.json file with only the necessary dependencies (express, mysql2) that can be installed with npm install without any --legacy-peer-deps or similar flags.
Include a simple server.js file to set up the Express server, handle routes, and connect to MySQL.
Ensure the project can be run by navigating to the project directory and running node server.js after installing dependencies with npm install.
Do not include any advanced features, complex configurations, or external APIs beyond what’s needed for this basic setup.
Please provide all the code files (HTML, CSS, JavaScript, server.js, and package.json) ready to use, with clear instructions on how to set up and run the project.

I’ve reviewed the current version of my "Newsletter/Magazine Management System" generated by you, and I need the following improvements:

Styling Issues:
The current CSS has poor contrast, with white text blending into the white background. Update the CSS to ensure all text is clearly visible with a dark or contrasting color (e.g., black or dark gray) against a light background (e.g., off-white or light gray).
Enhance the layout using Bootstrap to create a responsive, professional design with proper spacing, alignment, and padding. Ensure the "Manage Your Newsletters with Ease" section and "Why Choose Our System?" section are well-structured with appropriate headings, paragraphs, and buttons.
Improve the navigation bar to have a consistent, readable color scheme with visible "Login" and "Register" buttons that stand out.
Sample Data:
Add at least 3 sample newsletter articles, each with:
A title (e.g., "Tech Trends 2025", "Editor’s Pick: June Edition", "Subscriber Spotlight").
A short description (2-3 sentences).
A publication date (e.g., June 18, 2025, 05:36 PM IST).
Include 2 sample users: one Admin (e.g., admin@bms.edu, password: admin123) and one Subscriber (e.g., user@bms.edu, password: user123).
Add 1 sample magazine issue (e.g., "BMS Monthly - June 2025") containing the sample articles.