MariaDB Databases & MariaDB Setup in the Nexcess Cloud

Overview

MariaDB is an open-source relational database management system often used as a replacement for MySQL. Managing databases is a critical task for maintaining website functionality and data security. This guide explains how to manage your MariaDB setup using the Nexcess Client Portal. It covers the steps to create databases and users, retrieve and reset user passwords, and assign specific user permissions for Managed Magento and Flexible Cloud plans.

Managing Your MariaDB Setup

1. Login to my.nexcess.nethttps://my.nexcess.net using a super user account.
2. Navigate to the plan option as shown below screenshot.

3. Select the plan on which you wish to create or edit the database/user.
4. Select the database option from the menu shown on the screenshot below, where you can do the MariaDB setup on the account. It will take you to the MariaDB setup section, where you can see various options such as phpMyAdmin access and database/user creation.

5. If you wish to create a new database/user, then click on Add a database and user option.
6. Add database and user option will pop up a new screen, where you can create the new database and user. Once username and database are selected, click on Add. It will create both a database and a user.

7. If you only wish to create a database alone and want to assign an existing user to the newly created database, then you can select the Plus symbol next to the database. From there, you can create a new database alone.

The plus sign will pop a new window, as shown below. Once database details are filled, click on Add.

Obtaining the Password of a Newly Created User Database User

To obtain the password of a newly created database and user, following these steps:

1. Navigate to the user section under the Database menu, showing the MariaDB database available on the account.
2. Click on the + sign next to the newly created database user.
3. To access the database user’s password, click on View password option.
4. A new webpage will pop up on the screen, and you can see the view password option and click on it. Taking this action will display the password details of the database user.

How to Access or View the Password Once the View Password Option Expires

If the View Password Option expires, you can generate a new password for the MariaDB database user. Please note that after generating the new password, you must update the application configuration so that the website can connect to the database.

Assigning Different Users Access to the Newly Created Database

To assign different users access to the newly created database, follow these steps:

1. Click on the Control Panel menu option (you may need to “show more options” to see the control panel link).
2. Now click on the Launch control panel option; this will take you to the control panel.
3. Make sure you are adjusting settings for the correct domain name.

4. Once selected, correct domain name > click on Hosting Feature > MySQL > MariaDB database option.

Here you can identify the MariaDB database on which you want to assign a new user.

5. Select the Manage user option to assign additional users to the database.

6. The Manage User option will take you to a new screen where you can assign an existing user and permission for the database. Select the correct user from the dropdown option and grant all permissions. The drop down will show the MariaDB database list on the account.
7. Click on the Add option to complete the process.