How to Setup MySQL Server on Windows Server 2019 in AWS (+ phpMyAdmin)
How to Setup MySQL Server on Windows Server 2019 in AWS (+ phpMyAdmin): MySQL server comes pre-installed on Windows 2019 running MySQL Community Edition, PHP, Apache, PhpMyadmin & MySQL Workbench. Configure server as a standalone SQL server or SQL replication. Server can also be setup for InnoDB clustering for HA.
Developers and DBAs can visually design, develop and administer MySQL databases using Workbench UI. MySQL Workbench provides advanced data modeling, a flexible SQL editor, comprehensive administrative and migration tools.
This video will show how you can Setup MySQL Server on Windows Server 2019 in AWS.
Enjoy the Video.
⏰Timestamps⏰
00:00 Introduction to Setup MySQL Server on Windows Server 2019 in AWS
00:26 Create phpMy Admin
02:00 Establishing RDP Connection
03:22 Accessing php MyAdmin
04:00 Creating a new DB
05:02 Change mySQL root Password
05:41 Outro of Setup MySQL Server on Windows Server 2019 in AWS
🔗 Deploy MySQL Server on Windows Server 2019 in AWS (+ phpMyAdmin) Marketplace listing:
https://aws.amazon.com/marketplace/pp...
🔗 Deploy MySQL Server on Windows Server 2016 in AWS (+ phpMyAdmin) Marketplace listing:
https://aws.amazon.com/marketplace/pp...
🔗 How to Setup MySQL Server on Windows Server 2019 in AWS (Step-by-step Blog Post):
https://cloudinfrastructureservices.c...
MySQL Server Features:
-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 non transaction 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.