Guides and tutorials

Hundreds of tutorials and step by step guides carefully written by our support team.

Create MySQL or MariaDB database

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.

enter image description here

2. When you are already located in the Dashboard of the service, click on the option Database Management in the left side menu:

enter image description here

3. Then press the button Create DB or Create your first MariaDB DB:

enter image description here

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.

    enter image description here

Once you have created the database, you will have different options at your disposal:

  • Modify BDD MariaDB
  • Open PhpMyAdmin
  • Open Post it notes
  • Delete BDD MariaDB
More than 2000 m² of own facilities and Data Centers in Spain
Your privacy is important for us
We use our own cookies for the proper functioning of the site. In addition, third-party cookies are used for analytical purposes only. This information is not associated with any person so that personal identifying data is not stored, but is only information that is collected to identify the session, with the aim of facilitating the analysis of the website. You can change your preferences at any time by entering this website again. For more information about our cookie policy you can visit our Cookies. You can press the "Accept and close" button to give us your consent or you can access more detailed information and manage cookies.
More than 2000 m² of own facilities and Data Centers in Spain
Your privacy is important for us
We use our own cookies for the proper functioning of the site. In addition, third-party cookies are used for analytical purposes only. This information is not associated with any person so that personal identifying data is not stored, but is only information that is collected to identify the session, with the aim of facilitating the analysis of the website. You can change your preferences at any time by entering this website again. For more information about our cookie policy you can visit our Cookies. You can press the "Accept and close" button to give us your consent or you can access more detailed information and manage cookies.