Changing passwords for MariaDB users in the Nexcess Cloud

The correct database connection information provided in the Content Management System’s configuration files is vital for the website to establish a connection to its database and retrieve content.

Step by step instructions

1. Log into my.nexcess.net and choose one of your cloud hosting plans from the Plans page.
2. Choose the website you need to update database connection information for from the list under the cloud plan you opened.
3. Next, click your domain name to access your Site Dashboard. Alternatively, you can open an additional menu using the three dots to next to your website’s IP address. Choose Site Dashboard from the menu and access your website’s management interface:
4. Choose Databases from the main menu in the Site Dashboard for WordPress or WooCommerce. The Databases page will show the users and databases you have created for your site. Open databases from the plan’s main menu for Drupal and Magento products:
5. The Create User interface allows you to add new database users. Click the plus icons on the right to add new MariaDB users and databases. You can also launch phpMyAdmin to work with your website’s database and perform MariaDB administration tasks without using the command line interface.
6. Navigate to your website’s database’s MariaDB user, select the three dots on the right of the database name, and the choose Regenerate Password option.
7. Then, confirm you want to change your database user’s password. The system will reset the password automatically, and you can retrieve it.
8. Open the menu again and click View Password.
9. You can view your database’s MariaDB user password a limited number of times. Once the view limit is reached, you can no longer retrieve it from the Site Dashboard. You will need to regenerate it again. Make sure you save the new password and store it in a safe place.
10. Click the copy icon to save your new MariaDB user’s password. And then, finally, click Close to close the window.

Conclusion

You can perform MariaDB administration from the Databases page of the Site Dashboard or the main Plans interface. The MariaDB interface for creating users and databases ensures you can add and remove databases and database users and launch phpMyAdmin. After you have modified your website’s database connection information, you need to update your website’s configuration file to avoid any database connection issues.