Help & Support Swizzonic

  1. Support
  2. Hosting
  3. Setup
  4. Creation and management of MySql databases

Creation and management of MySql databases

The Swizzonic hosting solutions have the option of creating and managing MySql databases. For each SwizzHosting solution there is at least one database available, which you can configure from your cPanel.

Before following the procedures below, remember that any database name and database user name can only contain letters and numbers. Special characters are not allowed.

If you have configured a name containing different characters and are therefore no longer able to view the database, please contact our support team by ticket

First, log in to your cPanel, then follow one of two procedures.

Wizard

The simplest method of creating a database is the database wizard. Then click on MySql Database Wizard

Follow the steps provided on the screen to correctly create your new database and assign the user.

Manual procedure

1. In the Database section, click on Database Mysql

  1. Enter the name you want for the database in the Create new database field. Then click on Create Database
  1. Enter a username for the database and the password repeated twice. (The password must have a security level of at least 65).
  1. Click on Create User
  1. From the Assign user to database field, select the user you wish to assign and the database they will manage. Click Add
  1. Select the privileges for the specific user and finally click on Make changes
  1. Click on Back and your database will be created.

How do I manage the database?

There are two ways to access the database management:

  1. Online - Via cPanel you have access to PHPmyAdmin. In the Database section click on PhpmyAdmin.

You will then have online management of the database you have created.

  1. Remote - You can also access and manage your database remotely, via a client or an external application.

On this page you will find the information you need to use to log in (A) and you can add hosts that can connect to your database (B).


Was this article helpful?

You haven't found what you are looking for?

Contact our experts, they will be happy to help!

Contact us