Last updated 30th October 2020
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
- a Private SQL Web Hosting plan
- access to the OVHcloud Control Panel
Instructions
Creating a database
Log in to your OVHcloud Control Panel and select Web Cloud in the top navigation bar. Click Databases in the services bar on the left-hand side, 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 Databases in the services bar on the left-hand side, 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 Databases in the services bar on the left-hand side, 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 Databases in the services bar on the left-hand side, 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
Join our community of users on https://community.ovh.com.