A database is a set of data belonging to the same context and systematically stored for later use.
Any website that contains data and that can be consulted through a search tool on the website itself or that admits entering data through a text form needs a database to save, order and index that information.
All content managers or CMS (Content Management System), such as WordPress, Prestashop, Magento, Joomla, ... use a database to save and order all the data contained on the web, as well as their credentials access, themes, plugins, ...
For this reason all the hosting services of SW Hosting, either on a shared server or on an own server of the Cloud type, have the possibility of creating databases for web pages.
Although there are different types of databases according to their architecture, programming language, specific use, operating system on which they install, etc, ... the most common for use on websites are MySQL and Maria DB. In this manual we will explain how to create a database for hosting services based on Linux or Windows and that have the possibility of creating a MySQL / MariaDB database.
To create a database for your website from the SW Panel you must first create a PHP Hosting service or a Linux Domain in Cloud. The creation of these types of hosting services for your website are explained in the specific manuals "Create Hosting Service"
1. Once you have created the hosting for your website, you must indicate the service on which you want to create your database. For this you can use the search window located at the top of the SW Panel. Once located, click on your name to access your Dashboard.
2. When you are already located in the Dashboard of the service, click on the option Database Management in the left side menu:
3. Then press the button Create DB or Create your first MariaDB DB:
In compliance with the ISO 27001 standard on information security, the password will only be visible at the time of its creation. Later the password will not be visible and can only be modified.
4. In the next window you must indicate the following information:
The name of the database.
The database server.
The name of the new database user to create.
The IP from the host (Here you can specify the IP that can establish connection to the database, if we leave it blank by default it will assign "%" giving us access to any IP so that it can connect to the database)
The access password for the database.
The two configurable options regarding user permissions, based on the database, are the following:
User with read-only access to the Database -> The user can only read the content, but not modify, delete or create data or tables.
User with control over the Database -> The user can read, modify, delete or create data or tables
To finish creating the database and assigning the user with the corresponding permissions, click on the Create MariaDB button.
Once you have created the database, you will have different options at your disposal: