Skip to main content

Connecting to your Civo MySQL Database

After setting up your MySQL database with Civo, you can connect to it using various methods. This document guides you through obtaining connection details from the Civo dashboard and CLI, and connecting using the mysql client command.

Retrieving your Connection Details

Through the Civo Dashboard

To retrieve your database connection details, go to:

Navigate to the Civo Database section

  • Select your database to view the connection details, including:
    • Host IP/FQDN,
    • Username,
    • Password.

Select your database to view the connection details

Through the Civo CLI

Use the Civo CLI to manage your databases. Civo CLI allows you to create, update, delete, and list Civo Databases.

  • To list your databases, run:
civo database list

civo database list

  • To get the credentials of a specific database, use:
civo database credential [Database_Name] 

civo database credential

Connect to your Civo Database

The mysql client command is a popular choice for connecting to MySQL databases.

Execute the command without the password and enter it when prompted to ensure security:

mysql -h [MySQL host IP/FQDN] -u [username] -p


Connection Troubleshooting

If you encounter connection issues, verify that your credentials are correct and that the Civo firewall allows connections from your source IP address, if you need further assistance contact support.

Post-Connection Validation

Once connected, run a test query to validate the connection:


Ensure that the expected databases are listed and accessible.

Use Case Examples

For a comprehensive understanding of MySQL applications and use case examples, visit our MySQL tutorials. These tutorials offer practical insights and showcase real-world scenarios, helping you effectively implement and utilize MySQL in diverse environments.