I. Product Introduction

1. Overview
The MySQL image is built on public image "AlibabaCloud Linux 3.2104 LTS 64-bit  for ARM" and pre-installd only the MySQL database (Multiple MySQL versions including 5.5/5.6/5.7/8.0/8.4). It provides a clean environment without additional services. Users can install other required software (such as Nginx/PHP) as needed.

2. Software Parameters
Installation directory: `/usr/local/mysql`
Data directory: `/usr/local/mysql/data` (some images use `/data/mysql`)
MySQL configuration file: `/etc/my.cnf`

3. Default Password
The default password for the MySQL root user is `f7Y$ovcj~VpoPDm3`. It is recommended to change it immediately after logging in.
```sql
mysql> SET PASSWORD FOR root@localhost = PASSWORD('new_password');
```

4. Remote Connections
Remote access for the MySQL root user is disabled by default (only localhost connections are allowed). If remote access is required for a MySQL user, manually enable it.

Enable remote access:
```sql
# Enter your password and grant full access
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
# Grant access to a specific IP
GRANT ALL PRIVILEGES ON *.* TO root@"1.1.1.1" IDENTIFIED BY "your_password" WITH GRANT OPTION;
# Refresh privileges
FLUSH PRIVILEGES;
```

5. Port Configuration
To connect to the database remotely using clients such as Navicat or DBeaver, ensure port **3306** is open in both the server firewall and the Alibaba Cloud security group.

For more assistance, refer to the following documentation:
https://help.yunjiutian.com/project-4/doc-49/

6.Contact us
If you got problems please contact us on working days
Email admin@yunjiutian.com