Databases Management in Siteworx
SiteWorx provides tools to manage your website’s MySQL or MariaDB databases. The control panel allows you to create, manage, and delete databases without using the command line. Databases store the information for web applications like content management systems and e-commerce platforms.
For direct database administration, SiteWorx provides access to phpMyAdmin. You can use phpMyAdmin to perform tasks such as:
- Importing and exporting database backups.
- Running SQL queries.
- Editing table data directly.
The articles in this section explain how to perform common database management tasks in the SiteWorx control panel.
Creating a Non-Prefixed Database User Assigned to a SiteWorx Account
While InterWorx allows the ability for SiteWorx accounts to use non-prefixed databases and database users, it is currently not possible to create non-prefixed databases, or non-prefixed users, from the SiteWorx interface. However, it is possible to create non-prefixed databases and database users and automatically assign them to a SiteWorx account from the CLI.
How to change permissions for MySQL users
How Nexcess clients can use SiteWorx to change permissions for MySQL users.
How to change the password for a MySQL database user in Siteworx
How clients can use SiteWorx to change login passwords for MySQL users.
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.
How to create MySQL databases with SiteWorx
How Nexcess clients on physical (non-cloud) servers can use the SiteWorx control panel to create a MySQL database.
How to delete a MySQL database with SiteWorx
Learn how to delete a MySQL database with SiteWorx.
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.
How to import and export MySQL databases in SiteWorx
Learn how Nexcess clients can import and export MySQL databases with the phpMyAdmin control panel in SiteWorx.
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.
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.
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.
Managing Database Users in Siteworx
From the SiteWorx interface, SiteWorx users can create and manage MySQL database users.
Managing Databases in Siteworx
From the SiteWorx interface, SiteWorx users can create and manage MySQL databases.