Sriram Sanka

Databases | Cloud | Infrastructure | Security |

Archive for June, 2021

AWS- EC2 : Error while changing the IP Address in EC2 Security Groups

Posted by Sriram Sanka on June 12, 2021

Error while changing the IP Address in EC2 Security Groups. This happened ,as the user does not have access to change the IP in SG Group 2,after adding the below rule (Underlined Part) resolved this error.

{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "VisualEditor0",
"Effect": "Allow",
"Action": [
"ec2:RevokeSecurityGroupIngress",
"ec2:AuthorizeSecurityGroupEgress",
"ec2:AuthorizeSecurityGroupIngress",
"ec2:RevokeSecurityGroupEgress",
"ec2:DeleteSecurityGroup"
],
"Resource": [
"arn:aws:ec2:::security-group/sg-Group1",
"arn:aws:ec2:::security-group/sg-Group2"
]
},
{
"Sid": "VisualEditor1",
"Effect": "Allow",
"Action": [
"ec2:DescribeSecurityGroupReferences",
"ec2:DescribeVpcs",
"ec2:DescribeSecurityGroups",
"ec2:DescribeStaleSecurityGroups"
],
"Resource": "*"
}
]
}

Posted in Uncategorized | Tagged: , , | Leave a Comment »

Install MySQL 8 Community Server (mysql-community-server) on Azure VM(IAAS) Linux 8 CentOS

Posted by Sriram Sanka on June 11, 2021

Download and Add MySQL Yum Repository.

wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

Install the downloaded release package.

yum localinstall mysql80-community-release-el8-1.noarch.rpm

You can check that the MySQL Yum repository has been successfully added by the following command (If Yum Is not available, you can use dnf , instead.)

yum repolist enabled | grep "mysql.-community."

Installing MySQL

Linux 8 includes a MySQL module that is enabled by default., Disable the Default Module to avoid following Error.

yum -y install mysql-community-server

yum module disable mysql

yum install mysql-community-server

Start and Enable the Server

Get the temp Password before Secure Configurations.

Continue with the Options and change the Password.

Posted in Installation, Linux, MySql | Tagged: , , | Leave a Comment »