--- title: "Getting started with Cloud DB for MySQL" slug: "clouddbformysql-start-classic" updated: 2026-09-17T09:25:07Z published: 2026-09-17T09:25:07Z canonical: "guide.ncloud-docs.com/clouddbformysql-start-classic" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://guide.ncloud-docs.com/llms.txt > Use this file to discover all available pages before exploring further. # Getting started with Cloud DB for MySQL Available in Classic Getting started describes what you need to do to properly use Cloud DB for MySQL after reviewing Cloud DB for MySQL user environment, supported specifications, [Overall usage quickstart](/docs/en/clouddbformysql-procedure) and [glossary](/docs/en/clouddbformysql-glossary). The following is described in getting started: - How to create an application server in the NAVER Cloud Platform console. - How to test application server connection. - How to create MySQL Servers from the NAVER Cloud Platform console. - How to test MySQL Server connection. If you completed the above, then you've completed the basic procedure for using Cloud DB for MySQL. Afterward, you can perform the following tasks for more efficient server management and operation: - Event and notification (alarm) settings using NAVER Cloud Platform's Cloud Insight. - Permissions management for using NAVER Cloud Platform's Sub Account. - Storage of log files and backup files using NAVER Cloud Platform's Object Storage. - Setting DB server read load balancing using NAVER Cloud Platform's Load Balancer. The above tasks can be done from Cloud Insight, Sub Account, Object Storage, and Load Balancer after subscribing, rather than in Cloud DB for MySQL. They are not explained in detail in this guide. For detailed instructions, see [Cloud Insight user guide](/docs/en/cloudinsight-cloudinsightconsole), [Sub Account user guide](/docs/en/subaccount-overview), [Object Storage user guide](/docs/en/storage-storage-6-1), and [Load Balancer user guide](/docs/en/networking-loadbalancer-loadbalanceroverview). ## Create an application server To create an application server from the NAVER Cloud Platform console: Note This section provides a brief overview of how to create an application server. For more information on full creation methods, see the following guides: - [Server user guide (Classic)](/docs/en/server-start-classic) 1. Access the NAVER Cloud Platform console. 2. In the top-right corner, click **Region & Platform**. 3. Select your region and the **Classic** platform, then click **[Apply]**. 4. In the top-left corner, click **Menu**. 5. Navigate to **All services** > **Compute** > **Server**. 6. Click **[Create server]**. 7. Select the server image and click **[Next]**. 8. Enter the required information and click **[Next]**. 9. If you do not have an existing authentication key, then create a new authentication key and click **[Next]**. 10. If you do not have any ACG, create a new one. 11. After the final confirmation, click **[Create server]**. Caution The ACG name of the application server from Step 7 is used when adding ACG to the MySQL Server later on. ## Configure the connection environment To configure the server connection environment in the Classic environment of the NAVER Cloud Platform console, you must configure port forwarding. Note This section provides a brief overview of how to set up the access environment. For more information on setting up the access environment, see the following guide: - [Port forwarding guide (Classic)](/docs/en/server-manage-classic#%ED%8F%AC%ED%8A%B8%ED%8F%AC%EC%9B%8C%EB%94%A9%EC%84%A4%EC%A0%95) ### Configure port forwarding The following describes how to set port forwarding in Classic: 1. In the Classic environment of the NAVER Cloud Platform console, navigate to **Menu** > **All services** > **Compute** > **Server**. 2. Select the server for which you want to configure port forwarding, and then click **Menu** > **Configure port forwarding**. 3. Enter the external port number to configure and click **[Add]**. - The available external port range is 1,024–65,534. This external port can be used only for server access. 4. Click **[Apply]**. #### Check admin password To check the administrator (root) password required to access the application server, after configuring port forwarding: 1. In the Classic environment of the NAVER Cloud Platform console, navigate to **Menu** > **All services** > **Compute** > **Server**. 2. Click **[Server management and settings]** and click **Menu** > **Check administrator password menu**. 3. Enter the authentication key generated while creating the server. 4. Click **[Check password]**. 5. Check the password. ## Test the application server connection To test connectivity to the application server using the PuTTY terminal program: 1. Run PuTTY. 2. Enter the IP address and port number acquired from the access environment settings for **Host Name (or IP address)** and **Port**. ![clouddbformysql-start_01](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/clouddbformysql-start_01.png?sv=2026-02-06&spr=https&st=2026-10-27T15%3A59%3A32Z&se=2026-10-27T16%3A59%3A32Z&sr=c&sp=r&sig=W4noXGV4Snt31atKFIt6x8Rcl8HOImlEAM5zUzBAWzI%3D) 3. Click **[Open]**. 4. When the **PuTTY security alert** popup appears, click **[Accept]**. ![clouddbformysql-start_02](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/clouddbformysql-start_02.png?sv=2026-02-06&spr=https&st=2026-10-27T15%3A59%3A32Z&se=2026-10-27T16%3A59%3A32Z&sr=c&sp=r&sig=W4noXGV4Snt31atKFIt6x8Rcl8HOImlEAM5zUzBAWzI%3D) 5. When the cmd window for server access appears, enter the password you got from get admin password. ![clouddbformysql-start_03](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/clouddbformysql-start_03.png?sv=2026-02-06&spr=https&st=2026-10-27T15%3A59%3A32Z&se=2026-10-27T16%3A59%3A32Z&sr=c&sp=r&sig=W4noXGV4Snt31atKFIt6x8Rcl8HOImlEAM5zUzBAWzI%3D) Note You can change the password through the `passwd` commands. ## Create MySQL Server Some of the services provided by NAVER Cloud Platform require you to go through the subscription procedure from the console before the start of actual usage. However, for Cloud DB for MySQL, you can start using it upon creation of a MySQL Server without a separate subscribe step. To create a MySQL Server from the NAVER Cloud Platform console: Note - This section provides a brief overview of how to create a DB Server. For more information on full creation methods, see [Create MySQL Server](/docs/en/database-database-5-2#MySQLServer%EC%83%9D%EC%84%B1VPC). - Since Cloud DB for MySQL does not require an additional subscription step, there is no separate procedure for unsubscription. If you want to stop using Cloud DB for MySQL and prevent charges from incurring, then delete the MySQL Servers you created and were running. To delete MySQL Server, see [Delete MySQL Server](/docs/en/database-database-5-2#MySQLServer%EC%82%AD%EC%A0%9C). 1. In the Classic environment of the NAVER Cloud Platform console, navigate to **Menu** > **All services** > **Database** > **Cloud DB for MySQL**. 2. Click the **DB Server** menu. 3. Click **[Create DB Server]**. 4. When the subscribe interface appears, enter the required information and click **[Next]**. 5. Click **[Create]**. ## ACG settings To set the Access Control Group (ACG) for a MySQL server in the NAVER Cloud Platform console: Note This section provides a brief overview of how to set up ACG. For more information on how to set ACG, see [ACG user guide](/docs/en/server-acg-classic). 1. In the Classic environment of the NAVER Cloud Platform console, navigate to **Menu** > **All services** > **Database** > **Cloud DB for MySQL**. ![clouddbformysql-start_acg_vpc_ko.png](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/clouddbformysql-start_acg_vpc_en.png?sv=2026-02-06&spr=https&st=2026-10-27T15%3A59%3A32Z&se=2026-10-27T16%3A59%3A32Z&sr=c&sp=r&sig=W4noXGV4Snt31atKFIt6x8Rcl8HOImlEAM5zUzBAWzI%3D) 2. Click and select the ACG to set up, and then click **[Set ACG]**. - Select the ACG of the MySQL Server automatically created 3. Enter the ACG name of the application server in **Access source**. 4. Enter the port number in **Allowed port**. 5. Click **[Add]**. 6. Click **[Apply]**. ## Test the MySQL Server connection To test if you can connect properly to the created MySQL Server by installing the MySQL client: 1. Access the application server, run the following commands, and install MySQL. ``` [root@localhost ~] # yum -y install mysql mysql-server ``` ``` [root@localhost ~] # yum -y install https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm [root@localhost ~] # rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 [root@localhost ~] # yum -y install mysql-community-server [root@localhost ~] # mysqld --initialize-insecure --user=mysql [root@localhost ~] # systemctl start mysqld ``` ``` [root@localhost ~] # yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm [root@localhost ~] # rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 [root@localhost ~] # yum -y install mysql-community-server [root@localhost ~] # mysqld --initialize-insecure --user=mysql [root@localhost ~] # systemctl start mysqld ``` ``` [root@localhost ~] # sudo dnf install -y mysql-server [root@localhost ~] # sudo systemctl start mysqld ``` Note - Starting with CentOS 7, the default DB for MySQL installed with yum has changed to MariaDB, so you must run the above command to install it. - For MySQL 5.7 version, when restoring with Xtrabackup, you must add `innodb_undo_tablespaces = 2` to the **[mysqld]** part of the **my.cnf** file before `mysqld --initialize-insecure --user=mysql`. - CentOS 6.x or 6.x earlier - CentOS 7.x - MySQL 5.7 version - CentOS 7.x - MySQL 8.0 version - Rocky 8.x - 9.x version 2. Access the DB server by executing the following commands. ``` [root@localhost ~] # mysql -h ① Private domain name -u ②user_id -p --port ③DB access port -- Access success examples [root@localhost ~] # mysql -h db-gmcp.cdb.ntruss.com -umysql_dba -p --port 3306 Enter password: ********** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17199 Server version: 5.7.19-log MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ``` - You can check port number, user ID, and password required for DB access from the **DB Server** menu of the NAVER Cloud Platform console.