Is It Possible to Obtain or View the Old Password Once the View Password Option Expires?

No, but you can use the regenerate password option to generate a new password.

How Do We Access the Database that is Created within the Nexcess Portal?

You can access the database using the phpMyAdmin option under the database menu. More details can be found in the Using phpMyAdmin: Frequently Asked Questions (FAQ) article.

How Do We Enable Remote Access to the Database?

You can enable remote access to the database by accessing the control panel > Firewall Rules.

Can You Swap MySQL with MariaDB and Vice Versa?

Yes, it is possible to replace MySQL with MariaDB. MariaDB is considered to be a drop-in replacement for the corresponding MySQL version for example — MariaDB 10.2 and MySQL 5.7 and so and so forth.

With Regard to Database Performance, is MariaDB Better than MySQL?

The short answer is yes. When it comes to performing queries or replication, MariaDB is significantly faster than MySQL. Therefore, if you need a high-performance relational database solution, MariaDB is an excellent choice. Furthermore, MariaDB also supports a large number of concurrent of connections without much performance degradation.

Back to Help Docs Home

Databases

5 min read
MariaDB Databases & MariaDB Setup in the Nexcess Cloud
Learn how to create and manage MariaDB databases and users in the Nexcess Client Portal. This guide covers setup, password retrieval, and assigning user permissions.
Client Portal Databases File Management MySQL Sites and Stores
10 min read
Using rsync for backups on Linux/Unix systems
Learn what `rsync` is and how to use it for fast, reliable backups on Linux. Our guide covers incremental file transfers for local and remote syncs.
Databases File Management Sites and Stores
4 min read
Nexcess: MySQL & IP Whitelisting for Remote Access
It’s possible to allow MySQL remote connections from any host. Learn how to whitelist MySQL host IP. Grant MySQL remote access with this article.
Client Portal Databases Flexible Cloud Magento MySQL Sites and Stores
3 min read
Modifying Fields in Database Tables with PhpMyAdmin
Our tutorial walks you through examples of how to modify a field within your MySQL or MariaDB database. Learn to edit a field within a database table with phpMyAdmin.
Databases Tutorials
3 min read
How to create MySQL database user accounts in SiteWorx
How Nexcess clients on Siteworx can create a new MySQL database user account for a MySQL database.
Databases File Management Sites and Stores
1 min read
How to change the password for a MySQL database user in Siteworx
How clients can use SiteWorx to change login passwords for MySQL users.
Control Panel Databases File Management Sites and Stores SiteWorx
2 min read
How to change permissions for MySQL users
How Nexcess clients can use SiteWorx to change permissions for MySQL users.
Control Panel Databases File Management Sites and Stores SiteWorx
1 min read
How to show running MySQL queries in SiteWorx
Use phpMyAdmin from your SiteWorx account to show running MySQL queries following the guidance in the article.
Databases File Management MySQL Sites and Stores
1 min read
How to truncate MySQL tables in SiteWorx
Learn how Nexcess clients on physical (non-cloud) accounts can perform the truncate table operation for MySQL tables from SiteWorx.
Control Panel Databases File Management MySQL Sites and Stores SiteWorx
2 min read
How to import and export MySQL databases in SiteWorx
Learn how clients on physical (non-cloud) servers can import and export MySQL databases with the phpMyAdmin control panel in SiteWorx.
Control Panel Databases File Management SiteWorx
1 min read
How to show running MySQL queries in SiteWorx
If you are a Nexcess client on a physical (non-cloud) server, you can use phpMyAdmin from your SiteWorx account to show running MySQL queries following the guidance in the article.
Databases File Management
1 min read
How to conserve disk space in Magento
If you have a need to conserve disk space with regard to your Magento store, consider the list of safe candidates for deletion in this article — all of which take up large amounts of disk space.
Databases File Management Magento Sites and Stores