Deployment guide

MySQL on Windows

Overview

MySQL is the world's most popular open-source relational database, known for its reliability, performance, and ease of use.

This SecureAnyCloud AMI from the AWS Marketplace gives you MySQL on Windows Server, with MySQL Workbench preinstalled and Remote Desktop access. This guide covers deploying and configuring the AMI.

What you get:

MySQL (latest version), with the database listener on port 3306
The MySQL80 Windows Service, which starts automatically on boot
MySQL Workbench, preinstalled with preconfigured connection profiles
Randomly generated database credentials, stored on the desktop
Windows Server with Remote Desktop access
24/7 SecureAnyCloud support with a guaranteed 24-hour response SLA

Prerequisites

Before you launch this AMI, make sure that you have:

An active AWS account
An active subscription to the MySQL on Windows listing on AWS Marketplace
An EC2 key pair for password decryption
A Remote Desktop client application

Recommended instance type: t3.medium (2 vCPU, 4 GB RAM) or larger. The minimum requirements are 1 vCPU, 1 GB RAM, and 30 GB of disk space.

Launch the AMI

Go to the AWS Marketplace and search for "MySQL Windows SecureAnyCloud".
Select Continue to Subscribe, accept the terms, then select Continue to Configuration.
Select your preferred Region and Software Version.
Select Continue to Launch.
Choose Launch through EC2 for full control over the instance configuration.
Select your instance type (t3.medium is recommended).
Configure storage with a minimum of 30 GB gp3. Increase it for large databases.
Configure your Security Group with these inbound rules:
Port 3389 (TCP) from your IP address, for Remote Desktop (RDP) access.
Port 3306 (TCP) from your IP address, for the MySQL database listener.

Important: Restrict port 3306 to trusted application servers or your IP address only.

Select your EC2 key pair and launch the instance.

Retrieve the Windows Password

Wait for the EC2 instance to pass 2/2 status checks.

Open the AWS Console and go to EC2 > Instances.
Select your instance.
Select Actions > Security > Get Windows password.
Select Browse and upload your EC2 key pair .pem file.
Select Decrypt password.
Note the Username (Administrator) and the decrypted Password.

Connect via Remote Desktop

Open your Remote Desktop client.

On Windows:

Press Win + R, type mstsc, and press Enter.
Enter the public IP address of your instance.
Select Connect.

On macOS:

Open Microsoft Remote Desktop.
Select Add PC and enter the public IP address.
Double-click the connection to connect.

When prompted, enter these credentials:

Username: Administrator
Password: the decrypted value from Step 2

Retrieve MySQL Credentials

The image generates the MySQL database credentials randomly and stores them on the Desktop. Locate and open the file:

C:\Users\Administrator\Desktop\mysql-credentials.txt

This file contains the passwords for both the root user and the admin user.

Connect Using MySQL Workbench

MySQL Workbench is preinstalled with two preconfigured connection profiles:

Local instance MySQL80 connects as the root user via localhost:3306.
Local instance MySQL80 - ad... connects as the admin user via 127.0.0.1:3306.

To connect:

Double-click the MySQL Workbench shortcut on the Desktop.
Under MySQL Connections, select either the root or the admin profile.
When prompted for a password, enter the corresponding value from mysql-credentials.txt.
Select OK.

MySQL Workbench opens with the management panel on the left, the query editor in the center, and the connection details on the right.

Managing the MySQL Service

MySQL runs as a Windows Service named MySQL80 and starts automatically on boot.

To manage the service in Windows Services:

From the Start Menu, search for Services and open it.
Locate the MySQL80 service in the list.
Right-click the service and select Start, Stop, or Restart.

To manage using PowerShell:

# Check MySQL service status Get-Service -Name MySQL80
# Stop MySQL Stop-Service -Name MySQL80
# Start MySQL Start-Service -Name MySQL80
# Restart MySQL Restart-Service -Name MySQL80

Server Components

MySQL: latest (MySQL 8.0)
MySQL Workbench: included

Filesystem Layout

The C:\ drive is the system drive, with Windows, MySQL, and MySQL Workbench.

Key directories and files:

C:\Program Files\MySQL\MySQL Server 8.0: the MySQL server installation
C:\Program Files\MySQL\MySQL Server 8.0\data: the database data files
C:\Program Files\MySQL\MySQL Workbench: the Workbench installation
C:\Users\Administrator\Desktop\mysql-credentials.txt: the database credentials

Troubleshooting

Cannot connect to MySQL on port 3306

Verify that the MySQL80 service is running in Windows Services.
Check that your security group allows port 3306 from your IP address.
Test local connectivity from MySQL Workbench.
Check that Windows Firewall is not blocking port 3306.

MySQL Workbench shows an authentication error

Verify the credentials from mysql-credentials.txt.
Check that you are using the correct user (root or admin).
Ensure that the MySQL80 service is running.

Forgot MySQL credentials

Check the mysql-credentials.txt file on the Desktop.
If the file has been deleted, reset the root password using MySQL safe mode.

Cannot connect via RDP

Verify that the instance has passed 2/2 status checks.
Check that your security group allows port 3389 from your IP address.
Wait up to 15 minutes for the Windows password to become available.

Security Recommendations

Change the default passwords for both the root and admin users after your first login.
Change the Administrator password for Windows after your first login.
Delete the credentials file from the Desktop after you note the values.
Restrict port access: allow port 3306 only from trusted IP addresses.
Create application-specific users with minimal privileges.
Disable remote root login unless you specifically require it.
Enable SSL/TLS for encrypted database connections.
Back up regularly: use mysqldump or MySQL Enterprise Backup.
Enable Windows Update: keep the OS patched with the latest security updates.

Support

If you have any issues with this product, contact SecureAnyCloud support:

Email: sales@secureanycloud.com
Website: secureanycloud.com
Support hours: 24/7 with a guaranteed 24-hour response SLA

Deploy on AWS

Launch MySQL on Windows with 24/7 support from SecureAnyCloud.

View on Marketplace

Need Help?

Our support team is available 24/7.

sales@secureanycloud.com