# Check system information
$ uname -r          # Display kernel version
$ cat /etc/os-release  # Show distribution details

# Add MySQL YUM repository
$ wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
$ sudo yum localinstall -y mysql80-community-release-el7-3.noarch.rpm

# Install MySQL server
$ sudo yum install -y mysql-community-server

# Start and verify MySQL service
$ sudo systemctl start mysqld
$ sudo systemctl status mysqld
$ mysql --version

# Secure initial setup
$ sudo grep 'temporary password' /var/log/mysqld.log
$ mysql -u root -p  # Login with temporary password
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewSecurePass123!';
mysql> FLUSH PRIVILEGES;

# Adjust password policy (if needed)
mysql> SET GLOBAL validate_password.policy=LOW;
mysql> SET GLOBAL validate_password.length=6;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'simplepass';
mysql> FLUSH PRIVILEGES;

# Enable remote access
mysql> UPDATE mysql.user SET host='%' WHERE user='root';
mysql> FLUSH PRIVILEGES;

# Verify installation
$ mysql -u root -p -e "SELECT VERSION();"