How to setup MySQL Server on Windows in AWS
To install MySQL server on AWS, the best way is to use our AWS marketplace image that fully sets up a production ready MySQL server also running PHP, Apache, PhpMyadmin with MySQL connectors. Click on the link below to find our more information.
Getting Started
MySQL Windows Server on AWS
Once you’ve deployed our MySQL windows virtual machine to your AWS tenant its ready to go.
RDP into new MySQL server:
How to RDP to AWS Windows Instance
MySQL Server Details
MySQL database credentials are (also used for phpMyadmin login):
MYSQL Username: root
MYSQL Password: Password is the VM Instance ID. To find the Instance ID you will find on the top right of the desktop or within the AWS console under the EC2 VM properties
NOTE: If you find the root password doesn’t work. Wait 5 mins as during the first boot a start script is setting the root MySQL password and could still be running. You can see if its still running by viewing any Windows task schedule jobs. Wait for it to finish and then try logging in again.
MySQL location
C:\tools\mysql\current\
PHP Files location:
C:\php
Apache location
C:\Apache24
PhpMyadmin location:
C:\Apache24\htdocs\phpmyadmin
MySQL Server Ports
The following ports need to be opened in AWS if you are using a firewall appliance or any security groups.
3306 – TCP (MySQL)
33060 – TCP (MySQL X Protocol)
6446 – TCP MySQL Router
6447 – TCP MySQL Router
6448 – TCP InnoDB Cluster
6449 – TCP InnoDB Cluster
Apache Webserver Ports
TCP/80 – (http traffic)
TCP/443 – (https traffic)
To setup AWS firewall rules refer to – AWS Security Groups
Support
If you have any questions about the setup of our MySQL Server on Windows solution in AWS, leave your comments below and we will reply within 24 hours.
Alternatively have a look at https://www.mysql.com/why-mysql/white-papers/
Want some help (hire us)?
If you would like us to implement the MySQL server into your environment and fully configure it and get it up and running, get in contact with us and we will get you up and running asap
Related Posts:
- How to Install MySQL Server on Windows Server 2019 Tutorial
- How to Install MySQL Server on Windows 10 (Step by Step)
- How to Install MySQL Server on Ubuntu 21.04 (Step by Step Tutorial)
- How to Install MySQL Server on Ubuntu 20.04 Tutorial (Step by Step)
- How to Install MySQL Server on CentOS 8 (Database Setup Tutorial)
- MySQL vs SQL - What's the Difference (Pros and Cons)