AWS Deployment Azure Deployment
Summary
MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.
MySQL 8.0 builds on this momentum by delivering across the board improvements designed to enable innovative DBAs and developers to create and deploy the next generation of web, embedded, mobile and Cloud/SaaS/PaaS/DBaaS applications on the latest generation of development frameworks and hardware platforms.
CloudMint provides Enterprise Ready images of MySQL 8.0 on all public cloud ( AWS marketplace, Azure and Google Cloud Platform).
Highlights
MySQL 8.0 highlights include:
- Data dictionary – MySQL now incorporates a transactional data dictionary that stores information about database objects.
- Atomic Data Definition Statements – An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic transaction.
- Security and account management – These enhancements were added to improve security and enable greater DBA flexibility in account management
- Resource management – MySQL now supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group.
- Data type support – MySQL now supports use of expressions as default values in data type specifications.
- Window functions – MySQL now supports window functions that, for each row from a query, perform a calculation using rows related to that row.
- Connection management – MySQL Server now permits a TCP/IP port to be configured specifically for administrative connections.
AWS
Installation Instructions For Windows Installation Instructions For Ubuntu Installation Instructions For Redhat
Installation Instructions For Windows
Note: How to find PublicDNS in AWS
Step 1) RDP Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows instance on AWS Cloud
1) Connect to the virtual machine using following RDP credentials:
- Hostname: PublicDNS / IP of machine
- Port : 3389
Step 2) Database Login Details:
Please use MySQL root password TChangeh&33plz7@L for the MySQL configuration.
Once you are connected to the MySQL server, a welcome message is displayed and the mysql> prompt appears.
You shall be prompted for password where you can enter the password: TChangeh&33plz7@L
Note : Please change password immediately after first login.
You can reset your root password with the following statement:
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;
You can come out of mysql Prompt with “exit” command.
Step 3) MySQL Information:
Server version: MySQL 8.0 Community Server
Step 4) Other Information:
1.Default ports:
- MYSQL: 3306
Default ports: MySQL Port: 3306 this is by default not allowed on cloud firewall for security.
Configure custom inbound and outbound rules using this link
———————————————————————————————————————
Installation Instructions For Ubuntu
Note: How to find PublicDNS in AWS
Step 1) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to Ubuntu instance on AWS Cloud
1) Download Putty.
2) Connect to the virtual machine using SSH key Refer this link:
- Hostname: PublicDNS / IP of machine
- Port : 22
Step 2) Database Login Details:
Please use MySQL root password TChangeh&33plz7@L for the MySQL configuration.
After your login with SSH you can login to MySQL using
SSH shell> mysql -u root -p
You shall be prompted for password where you can enter the password: TChangeh&33plz7@L
Once you are connected to the MySQL server, a welcome message is displayed and the mysql> prompt appears
Note : Please change password immediately after first login.
You can reset your root password with the following statement:
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;
You can come out of mysql Prompt with “exit” command.
Step 3) MySQL Information:
Server version: 8.0 MySQL Community Server
MySQL Services:
Using your Unix Login you can perform below actions on MySQL service
- To start MySQL Service: sudo service mysql start
- To stop MySQL Service: sudo service mysql stop
- To restart MySQL Service: sudo service mysql restart
- To get status of MySQL Service: sudo service mysql status
Step 4) Other Information:
1.Default ports:
- MYSQL: 3306
Default ports: MySQL Port: 3306 this is by default not allowed on cloud firewall for security.
Installation Instructions For Redhat
Note: How to find PublicDNS in AWS
Step 1) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to Redhat instance on AWS Cloud
1) Download Putty.
2) Connect to the virtual machine using SSH key Refer this link:
- Hostname: PublicDNS / IP of machine
- Port : 22
Step 2) Database Login Details:
Please use MySQL root password TChangeh&33plz7@L for the MySQL configuration.
After your login with SSH you can login to MySQL using
SSH shell> mysql -u root -p
You shall be prompted for password where you can enter the password: TChangeh&33plz7@L
Once you are connected to the MySQL server, a welcome message is displayed and the mysql> prompt appears
Note : Please change password immediately after first login.
You can reset your root password with the following statement:
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;
You can come out of mysql Prompt with “exit” command.
Step 3) MySQL Information:
Server version: 8.0 MySQL Community Server
MySQL Services:
Using your Unix Login you can perform below actions on MySQL service
- To start MySQL Service: sudo systemctl start mysqld
- To stop MySQL Service: sudo systemctl stop mysqld
- To restart MySQL Service: sudo systemctl restart mysqld
- To get status of MySQL Service: sudo systemctl status mysqld
Step 4) Other Information:
1.Default ports:
- MYSQL: 3306
Default ports: MySQL Port: 3306 this is by default not allowed on cloud firewall for security.
Azure
Installation Instructions For Ubuntu Installation Instructions For CentOS Installation Instructions For Windows
Note: How to find PublicDNS in Azure
Step1 ) RDP Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows instance on Azure Cloud
Connect to virtual machine using following RDP credentials:
- Hostname: PublicDNS / IP of machine
- Port : 3389
Username: Your chosen username when you created the machine ( For example: Azureuser)
Password : Your Chosen Password when you created the machine ( How to reset the password if you do not remember)
Step 2) Database Login Details:
Please use MySQL root password TChangeh&33plz7@L for the MySQL configuration.
Step 3) Choose Start, expand All Programs, and then select PHP
Step 4) Other Information:
1.Default installation path: will be in your root folder “C:inetpubwwwroot”
2.Default ports:
- Windows Machines: RDP Port – 3389
- Http: 80
- Https: 443
Configure custom inbound and outbound rules using this link
Installation Instructions For Ubuntu
Note: How to find PublicDNS in Azure
Step 1) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to Ubuntu instance on Azure Cloud
1) Download Putty.
2) Connect to the virtual machine using following SSH credentials:
- Hostname: PublicDNS / IP of machine
- Port : 22
Username: Your chosen username when you created the machine ( For example: Azureuser)
Password: Your Chosen Password when you created the machine ( How to reset the password if you do not remember)
Step 2) Database Login Details:
Please use MySQL root password TChangeh&33plz7@L for the MySQL configuration.
After your login with SSH you can login to MySQL using
SSH shell> mysql -u root -p
You shall be prompted for password where you can enter the password: TChangeh&33plz7@L
Once you are connected to the MySQL server, a welcome message is displayed and the mysql> prompt appears
Note : Please change password immediately after first login.
You can reset your root password with the following statement:
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;
You can come out of mysql Prompt with “exit” command.
Step 3) MySQL Information:
Server version: 8.0 MySQL Community Server
MySQL Services:
Using your Unix Login you can perform below actions on MySQL service
To start MySQL Service: sudo service mysql start
To stop MySQL Service: sudo service mysql stop
To restart MySQL Service: sudo service mysql restart
To get status of MySQL Service: sudo service mysql status
Step 4) Other Information:
1.Default ports:
- MYSQL: 3306
Default ports: MySQL Port : 3306 this is by default not allowed on cloud firewall for security.
Installation Instructions For CentOS
Note : How to find PublicDNS in Azure
Step 1) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to CentOS instance on Azure Cloud
1) Download Putty.
2) Connect to the virtual machine using following SSH credentials:
- Hostname: PublicDNS / IP of machine
- Port : 22
Username: Your chosen username when you created the machine ( For example: Azureuser)
Password: Your Chosen Password when you created the machine ( How to reset the password if you do not remember)
Step 2) Database Login Details:
Please use MySQL root password TChangeh&33plz7@L for the MySQL configuration.
After your login with SSH you can login to MySQL using
SSH shell> mysql -u root -p
You shall be prompted for password where you can enter the password: TChangeh&33plz7@L
Once you are connected to the MySQL server, a welcome message is displayed and the mysql> prompt appears
Note : Please change password immediately after first login.
You can reset your root password with the following statement:
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;
You can come out of mysql Prompt with “exit” command.
Step 3) MySQL Information:
Server version: MySQL Community Server
MySQL Services:
Using your Unix Login you can perform below actions on MySQL service
- To start MySQL Service: sudo systemctl start mysqld
- To stop MySQL Service: sudo systemctl stop mysqld
- To restart MySQL Service: sudo systemctl restart mysqld
- To get status of MySQL Service: sudo systemctl status mysqld
Step 4) Other Information:
1.Default ports:
- MYSQL: 3306
Default ports: MySQL Port : 3306 this is by default not allowed on cloud firewall for security.
Configure custom inbound and outbound rules using this link
Installation Instructions For Windows Installation Instructions For Ubuntu Installation Instructions For Redhat
Installation Instructions For Windows
Step 1) RDP Connection: To initialize the DB Server connect to the deployed instance, Please follow Instructions to Connect to Windows instance on Google Cloud
Step 2) Database Login Details:
For local MySQL root password, please use the temporary password generated automatically during image creation
i) Please connect to Remote Desktop as given in step 2 to ensure stack is properly configured and DB is initialized.
ii) You can use MySQL server instance as localhost, username root
If you have closed the deployment page you can also get the MySQL root password from VM Details “Custom metadata” Section
Installation Instructions For Ubuntu
Step 1) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to Ubuntu instance on Google Cloud
1) Download Putty.
2) Connect to the virtual machine using SSH key
-
- Hostname: PublicDNS / IP of machine
- Port : 22
Step 2) Database Login Details:
For local MySQL root password, please use the temporary password generated automatically during image creation
i) Please connect to Remote Desktop as given in step 2 to ensure stack is properly configured and DB is initialized.
ii) You can use MySQL server instance as localhost, username root
Step 3) MySQL Information:
Server version: 8.0 MySQL Community Server
MySQL Services:
Using your Unix Login you can perform below actions on MySQL service
- To start MySQL Service: sudo service mysql start
- To stop MySQL Service: sudo service mysql stop
- To restart MySQL Service: sudo service mysql restart
- To get status of MySQL Service: sudo service mysql status
Step 4) Other Information:
1.Default ports:
- Linux Machines: SSH Port – 22
- MYSQL: 3306
Installation Instructions For Redhat
Step 1) VM Creation:
1.Click the Launch on Compute Engine button to choose the hardware and network settings.
2.You can see at this page, an overview of CloudMint Image as well as some estimated costs of VM.
3.In the settings page, you can choose the number of CPUs and amount of RAM, the disk size and type etc.
Step 2) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to Redhat instance on Google Cloud
1) Download Putty.
2) Connect to the virtual machine using SSH key
- Hostname: PublicDNS / IP of machine
- Port : 22
Step 3) Database Login Details:
For local MySQL root password, please use the temporary password generated automatically during image creation
i) Please connect to Remote Desktop as given in step 2 to ensure stack is properly configured and DB is initialized.
ii) You can use MySQL server instance as localhost, username root
Step 4) MySQL Information:
Server version: 8.0 MySQL Community Server
MySQL Services:
Using your Unix Login you can perform below actions on MySQL service
- To start MySQL Service: sudo systemctl start mysqld
- To stop MySQL Service: sudo systemctl stop mysqld
- To restart MySQL Service: sudo systemctl restart mysqld
- To get status of MySQL Service: sudo systemctl status mysqld
Step 5) Other Information:
1.Default ports:
- Linux Machines: SSH Port – 22
- MYSQL: 3306
