MySQL8.4 LTS on CentOS Stream 9 Latest with support by Hanwei
Product Overview
This product has charges associated with it for seller support. This is open source software, which is repackaged by Hanwei. The additional cost is applicable to the extended support of 24-hour response time.
This AMI contains Mysql-8.4 LTS on CentOS Stream 9 and includes support.
Perform a minimal installation of CentOS Stream 9 and update it to the latest version.
OS Version: CentOS Stream 9
Mysql Version: MySQL-8.4 LTS
CentOS Stream 9 is a Linux enterprise-class operating system that is functionally compatible with its upstream source, Red Hat Enterprise Linux (RHEL).
MySQL is an open-source relational database management system (RDBMS) that uses structured query language (SQL) for managing and manipulating data. It is known for its speed, reliability, and ease of use, making it a popular choice for web applications and data-driven projects.
How To Use
1.Connection Methods
ssh as user 'ec2-user' to the running instance and use sudo to run commands requiring root access.Use "sudo su - root" to switch to root.
To connect to CentOS Stream 9, you need to update the SSH connection tool to a higher version. If using xshell for connection, xshell7 or higher version is required. Connecting to Centos Stream 9 via SSH using a lower version of xshell will result in unsuccessful connection.
2.MySQL Management
To start/stop/status mysql Service: sudo systemctl start/stop/status mysqld
The default password for MySQL is: Mysql#$2024
To log in locally, use the command: sudo mysql -uroot -p'Mysql#$2024'
To change the root password for MySQL, follow these steps:
1.#sudo mysql -u root -p'Mysql#$2024'
2.mysql>ALTER USER 'root'@'%' IDENTIFIED BY 'YOUR_PASSWORD';
3.mysql>FLUSH PRIVILEGES;
3.Configuration Information
Configuration file:
/etc/my.cnf.
Please configure the security group to allow access to SSH port 22, and mysql ports 3306 for a limited set of IP addresses.
Version
Categories
Operating System
Linux/Unix, CentOS CentOS Stream 9
Delivery Methods