Creating databases and users on your database server
Find out how to create a database on your database server
Last updated 15rd February 2023
Objective
A database (DB) is used to store what are known as dynamic elements, such as comments or articles. These databases are used in virtually all modern content management systems (CMS), such as WordPress or Joomla!.
This guide explains how to create a database on your database server and give access to users.
Requirements
- You must have a Web Cloud Databases instance (included in a Performance web hosting plan).
- You must be logged in to your OVHcloud Control Panel.
Instructions
Creating a database
Log in to your OVHcloud Control Panel and select Web Cloud in the top navigation bar. Click Web Cloud Databases, then choose the SQL instance concerned. Click on the Databases tab, then on Add database.
Fill in the fields by following the criteria listed. You can create a user directly by ticking the Create User box.
- Database name (obligatory): this will be your database’s name.
- Username: This is name of the user that can log in to your database and perform requests (only applicable if the Create User box is ticked).
- Rights (only if the box is ticked): the permissions that will be associated with the user on the database. For standard usage, select
Administrator. The permissions can be modified as follows. - Password/Confirm password (only if the box is ticked): enter a password, then confirm it.
Finally, click Confirm.
Adding a user
To use an OVHcloud database server, you need to create users with specific rights to connect to a database.
Log in to your OVHcloud Control Panel and select Web Cloud in the top navigation bar. Click Web Cloud Databases, then choose the database name concerned. Next, switch to the Users and rights tab and click Add user.
Enter a “username” and a “password”, then click Confirm.
Managing user rights
To allow a user to perform actions on a database, it is necessary to assign permissions to the user.
Log in to your OVHcloud Control Panel and select Web Cloud in the top navigation bar. Click Web Cloud Databases, then choose the database name concerned. Next, switch to the Users and rights tab. Click on the ... button to the right of the user concerned, then on Manage rights.
In the left-hand column, Database, you will see a list of the databases on your database server.
The 3 types of permissions proposed are described below:
Administrator: Authorisation of the following queries: Select/Insert/Update/Delete/Create/Alter/Drop.Reading/Writing: Authorisation of the following queries: Select/Insert/Update/Delete.Read: Authorisation of Select queries.None: No database rights.
The distribution of rights mentioned above is unique to OVHcloud. This will allow a user with Administrator rights to use DLL (Data Definition Language) and DML (Data Manipulation Language), while a user with Reading/Writing rights will only use DML.
Deleting a database
Before deleting a database on a database server, there is no checking of the contents of the database. It will be deleted even if data is still stored in it, therefore it is recommended that a backup is created and downloaded from your side before any deletion.
Log in to your OVHcloud Control Panel and select Web Cloud in the top navigation bar. Click Web Cloud Databases, then choose the SQL instance concerned.
To delete a database on your database server, go to the Databases tab, then click on the ... button to the right of the database concerned, then click Delete the database.
Go further
For specialised services (SEO, development, etc.), contact OVHcloud partners.
If you would like assistance using and configuring your OVHcloud solutions, please refer to our support offers.
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.