Articles in this category
Accessing the website database in the Nexcess Client Portal
You can access your website database from the Site Dashboard within the Nexcess Client Portal by using the phpMyAdmin utility as an excellen…
Adding MySQL Users to Databases
You can create MySQL users to help you organize your database management, giving each user access to specific databases and specific privile…
Allowing Remote Database Access
Remote database access may be needed for third-party apps but is disabled by default due to security risks. Learn when and how to enable&hel…
Allowing Remote Database Access in Interworx
The InterWorx Control panel allows the ability to manage multiple external MySQL servers from a single installation of InterWorx, via MySQL…
Assign Read-Only Permission for a Database User in Cloud Sites
Limit user access and secure your Cloud Sites data. Learn how to easily assign read-only permissions for your MSSQL and MariaDB database use…
Backing Up a MySQL Database
Protect your website data before making major changes. Learn how to manually back up your MySQL databases using cPanel, the command line, or…
Backup a Cloud Sites MSSQL Database Using a cron
Follow these steps to create a cron to back up your MSSQL databases.
Backup Your MSSQL Database in Cloud Sites
Regularly backing up your database is crucial for site maintenance on Cloud Sites. To manually backup your MSSQL database, access myLittleAd…
Batch converting MySQL table engines
MySQL batch table engine conversion: MyISAM InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*
Change a Database User Password in Cloud Sites
This article will show you how to change database user passwords in Cloud Sites.
Change a MySQL User Password
Changing MySQL passwords to something new and secure is easy via the command line.
Change a MySQL User Password via cPanel
If you aren't familiar with using the command line interface, using cPanel makes it easy to change MySQL user passwords.