Mysql 5.7 on Rocky8 with support by Fleximg

Usage Instructions: Connect to SSH Login using 'rocky' user and ssh public key authentication Usage Instructions: To connect to your instance, you will need to use SSH over port 22. You can use the standard AWS method of connecting to an instance as described here: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/AccessingInstances.html 

start MySQL Service:sudo systemctl start mysqld stop MySQL Service:sudo systemctl stop mysqld restart MySQL Service:sudo systemctl restart mysqld To get status of MySQL Service:sudo systemctl status mysqld Default ports: MySQL Port : 3306 this is by default not allowed on cloud firewall for security. Please allow SSH port 22 and MySQL port 3306 to limited IPs for access.

MySQL default temporary password and first login password: Step 1: Enter the command mysql -u root -p Step 2: Enter the temporary password: cC6HStQuQG!4

If you want to login to your MySQL server as root using an external program such as phpMyAdmin Navicat. The first one is to change the authentication method from caching_sha2_password to mysql_native_password. You can do that by running the following command: Step 1: ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY "your new password"; Refer document - https://dev.mysql.com/doc/refman/5.7/en/alter-user.html  Step 2: FLUSH PRIVILEGES;

Mysql default configuration file path :/etc/my.cnf Mysql default datadir path:/var/lib/mysql Mysql default log file:/var/log/mysqld.log