Getting started with MySQL and MariaDB

Using Your Databases

Last updated 29th June 2022

Objective

Do you want to use MySQL or MariaDB for your databases?

What is a MySQL database?

MySQL is a relational database management system developed for increased read performance, unlike other systems.

This is an open-source engine, whose parent company is Oracle.

What is a MariaDB database?

MariaDB is a derivative (fork) of MySQL.

This engine is 100% compatible, and is "freer" than its sibling MySQL. All the bugs and roadmaps are freely accessible, unlike the Oracle version. In addition, the storage database InnoDB has been replaced by XtraDB and other optimisations, promising performance gains.

Find out how to create and manage your MySQL or MariaDB databases

Requirements

Instructions

Logging in to the database

Please note that this service does not give you access to the Host but to the databases hosted on the Host. Generic SQL commands work with no issues, and HeidiSQL or SQuirreL SQL software is fully compatible.

As MariaDB is a fork of MySQL, the different commands are the same for the 2 types of database.

To log in to your database, make sure that you have:

  • The address of your CloudDB instance
  • The port of your CloudDB instance
  • The username of your CloudDB instance
  • The password associated with the user
  • The database name

All this information is available in the OVHcloud Control Panel.

Please also read our guide on getting started with the CloudDB service.

Connect via the command line

mysql --host=server --user=user --port=port --password=password database_name

Connect from a PHP script

1. <?php
2. $db = new PDO('mysql:host=host;port=port;dbname=dbname', 'username', 'password');
3. ?>

Connect from software (SQuirreL SQL)

  • Launch SQuirreL SQL and click on Aliases, then on +.

launch SQuirreL SQL

  • Fill in the fields below and then confirm by clicking OK :
    • Name: Choose a name
    • Driver: Choose PostgreSQL
    • URL: Enter the server address and port in the following form jdbc:postgresql://server:port/database
    • User Name: Enter the username
    • Password: Enter the password

config connection

  • Confirm again by clicking the button Connect.

valid connection

You will now be connected to your database:

config connection

Connecting via phpMyAdmin

You can use phpMyAdmin to explore the contents of your database. To do this, install phpMyAdmin on your own server or web hosting plan. During this installation, make sure that the information on your CloudDB server and the database you want are correctly configured so that phpMyAdmin can connect to it.

Export and import a MySQL or MariaDB database

  • Export your database via the command line
mysqldump --host=server --user=user --port=port --password=password database_name > database_name.sql
  • Import your database via the command line
cat database_name.sql | mysql --host=server --user=user --port=port --password=password database_name

In some cases, the RAM available in your CloudDB instance may not be sufficient to perform the desired export or import. If this is the case, we recommend using the OVHcloud tool in the OVHcloud Control Panel. See the Getting started with CloudDB service documentation if necessary.

Go further

Join our community of users on https://community.ovh.com/en/.


Did you find this guide useful?

Please feel free to give any suggestions in order to improve this documentation.

Whether your feedback is about images, content, or structure, please share it, so that we can improve it together.

Your support requests will not be processed via this form. To do this, please use the "Create a ticket" form.

Thank you. Your feedback has been received.


These guides might also interest you...

OVHcloud Community

Access your community space. Ask questions, search for information, post content, and interact with other OVHcloud Community members.

Discuss with the OVHcloud community

In accordance with the 2006/112/CE Directive, modified on 01/01/2015, prices incl. VAT may vary according to the customer's country of residence
(by default, the prices displayed are inclusive of the UK VAT in force).