---
title: "MySQL® - Configure an instance to accept incoming connections"
description: "Learn how to configure your MySQL® instance to accept incoming connections."
url: https://docs.us.ovhcloud.com/en/public-cloud/databases/mysql-configure-instance-accept-incoming-connections
lang: en
---
> For AI agents: the complete documentation index is available at https://docs.us.ovhcloud.com/en/llms.txt, the full documentation bundle is available at https://docs.us.ovhcloud.com/en/llms-full.txt.

# MySQL® - Configure an instance to accept incoming connections

**Learn how to configure your MySQL® instance to accept incoming connections.**

Cloud Databases allow you to focus on building and deploying cloud applications while OVHcloud takes care of the database infrastructure and maintenance in operational conditions.

 

## Requirements

- A [Public Cloud project](https://us.ovhcloud.com/public-cloud/) in your OVHcloud account
- Access to the [OVHcloud Control Panel](https://manager.us.ovhcloud.com)
- A MySQL® database running on your OVHcloud Cloud Databases ([this guide](https://docs.us.ovhcloud.com/en/public-cloud/databases/getting-started.md) can help you to meet this requirement)

 

## Instructions

### Configure your MySQL[®](#go-further) instance to accept incoming connections

Before establishing a connection, we must verify that our MySQL® instance is properly configured.

Log in to your [OVHcloud Control Panel](https://manager.us.ovhcloud.com) and select your MySQL® instance via the `Public Cloud` and `Databases` menus.

 

#### Step 1: Verify your user roles and password

Select the `Users` tab. Verify that you have a user and a configured password. If you don't remember the user's password, you can either create a new user or regenerate the password of an existing user.

**Warning:**

**NOTE:** Be careful! By doing so, you will need to update all the places where you already use this user/password pair.

This first user, **avnadmin**, is pre-configured during the service installation and comes with the following grants:

```sql
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO "avnadmin"@"%" WITH GRANT OPTION

GRANT REPLICATION_APPLIER,ROLE_ADMIN ON *.* TO "avnadmin"@"%" WITH GRANT OPTION
```

 

You can add more users by selecting the `Users` tab and clicking the `+ Add user` button.

Enter a username, then click `Create User →`.

**Note:**

You can delete a user or regenerate a password via the _more options_ `...` button in the `Users & Roles` table.

 

#### Step 2: Authorize incoming connections from the MySQL® client

**Warning:**

**NOTE:** For security reasons, the default network configuration doesn't allow any incoming connections. It is thus critical that you authorize suitable IP addresses to successfully access your database.

In this step, select the `Configuration` tab. IP addresses must be authorized here before they can connect to your database.

Enter an IP and a description, then click the "add" `+` button.

Click the `Save changes` button when you have added all the IPs you wish to authorize.

You can edit and retract database access via the _more options_ `...` button in the IP table.

**Note:**

If you want to allow connections from the outside, you can enter the IP 0.0.0.0/0. Please use it carefully.

 

#### Collect required information

Select the `Dashboard` tab to find the required login credentials in the **Connection Information** section.

 

Select the `Databases` tab to get the database name.

 

## Go further

Visit the [GitHub examples repository](https://github.com/ovh/public-cloud-databases-examples/tree/main/databases/mysql) to find out how to connect to your database with several languages.

Browse all the [Databases guides](https://docs.us.ovhcloud.com/en/public-cloud/databases/landing-page-databases.md).

Browse the rest of the [OVHcloud US documentation](https://docs.us.ovhcloud.com/en/index.md) for guides on our other products and services.

Learn more about [Managed Databases](https://us.ovhcloud.com/public-cloud/databases/) on the OVHcloud US website.

OVHcloud Managed Databases and Analytics:

- Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs.
- Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation.
- MongoDB® is a registered trademark of MongoDB, Inc.
- MySQL® is a registered trademark of Oracle and/or its affiliates.
- PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.