Setup MySQL Server on Windows Server 2025/2022 in Azure

To setup and install MySQL server on Windows Server 2022 or 2025 in Azure use our Azure marketplace listings to deploy Mysql virtual machine straight into your Azure tenant. MySQL Server using XAMPP on Windows Server in Azure provides an efficient and robust platform for database management and web hosting. XAMPP combines Apache, MySQL, PHPMyAdmin, PHP, and Perl into a single package, offering an ideal environment for developers and organizations looking for a seamless and flexible solution. 

Run MySQL on Windows Server Azure

MySQL on Windows Server 2025 in Azure

MySQL on Windows Server 2022 in Azure

Table of Contents

MySQL Server features

  • MySQL is a relational database management system (RDBMS) based on the SQL (Structured Query Language) queries.
  • Tested with different compilers.
  • CMake for greater portability.
  • Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL tool.
  • Uses multi-layered server design with independent modules. 
  • Fully multithreaded by using kernel threads, to use multiple CPUs if they are available.
  • Transactional and nontransactional storage engines.
  • Uses very fast B-tree disk tables  with index compression.
  • Designed to make it relatively easy to add other storage engines. This is useful if you want to provide an SQL interface for an in-house database.
  • Uses a very fast thread-based memory allocation system.
  • Executes very fast joins using an optimized nested-loop join.
  • Implements in-memory hash tables, which are used as temporary tables.
  • Implements SQL functions using a highly optimized class library that should be as fast as possible. Usually there is no memory allocation at all after query initialization.
  • Multilingual: APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby.

Getting Started with MySQL on Windows Server

Once you’ve deployed MySQL on Windows server, the first step is to RDP into the new instance once it has fully booted up.  The following links explain how to connect the VM once it has finished being deployed:

 

 

Once logged in, you’re now ready to start using your MySQL Server, follow the steps below to start using MySQL:

MySQL Server using XAMPP on Windows Server on Azure

MySQL server on Windows in Azure is easy to setup, operate and easy to scale.

 

Once you’ve deployed MySQL Server on Windows virtual machine to your Azure tenant it is ready to go.

Root password is blank, its recommended to set a password for your MySQL root account.

Start XAMPP for MySQL and Apache

This solution uses XAMPP,  making it easier to manage Apache, MySQL and FTP. Right click on XAMPP Control Panel on the desktop and choose Run as Administrator.

 

Once opened, click on start Apache and start MySQL

You’re now ready to start using MySQL either via PHPMyAdmin or via the shell.

MySQL Server Details

MySQL database credentials are (also used for phpMyadmin login):

 

MYSQL Username: root

MYSQL Password: Password is blank, its recommended to set a strong password.

 

 

MySQL location

C:\xampp\mysql

 

Apache location

C:\xampp\apache

Web Root: C:\xampp\htdocs

 

PhpMyadmin location:

 

http://localhost/phpmyadmin/

 

C:\xampp\htdocs\phpmyadmin

MySQL Server Ports

The following ports need to be opened in Azure if you are using a firewall appliance or any Azure NSG’s.  

 

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 Azure firewall rules refer to – Azure Network Security Groups

MySQL Support/Documention

If you have any questions about the setup of our MySQL Server on Windows solution in Azure, leave your comments below and we will reply within 24 hours.

 

Alternatively have a look at MySQL Documentation: https://www.mysql.com/why-mysql/white-papers/

 

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.

Disclaimer: MySQL is a registered trademark of Oracle Corporation and is licensed under GPL license. This image is maintanined by Cloud Infrastructure Services. No warrantee of any kind, express or implied, is included with this software. Use at your risk, responsibility for damages (if any) to anyone resulting from the use of this software rest entirely with the user. The author is not responsible for any damage that its use could cause.

Avatar for Andrew Fitzgerald
Andrew Fitzgerald

Cloud Solution Architect. Helping customers transform their business to the cloud. 20 years experience working in complex infrastructure environments and a Microsoft Certified Solutions Expert on everything Cloud.

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x