Category

Databases

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 excellent tool…
3 min read
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 privileges. You can…
6 min read
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…
3 min read
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 users.
2 min read
Backup a Cloud Sites MSSQL Database Using a cron
Follow these steps to create a cron to back up your MSSQL databases.
5 min read
Batch converting MySQL table engines
MySQL batch table engine conversion: MyISAM InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*
3 min read
Change a Database User Password in Cloud Sites
This article will show you how to change database user passwords in Cloud Sites.
1 min read
Change a MySQL User Password
Changing MySQL passwords to something new and secure is easy via the command line.
2 min read
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.
1 min read
Changing passwords for MariaDB users in the Nexcess Cloud
Nexcess Cloud web hosting plans provide a great way to manage your website databases and database MariaDB users from the Nexcess Client Portal. Learn…
3 min read
Checking Your MySQL Version
If you are using MySQL databases, you might need to occasionally check the version of MySQL that is installed on your server. It's easy…
2 min read
Convert MyISAM to InnoDB tables for database performance
With regard to database tables and storage engines, after learning why we would want to convert MyISAM to InnoDB for better performance, let’s review…
10 min read