Grant, modify, and delete MySQL user permissions for a Magento/Flex Cloud Plan easily using the Nexcess Cloud SiteWorx Control Panel in the Client Portal.
Are you a Nexcess client using a /? This page contains information about how to grant, modify, and delete permissions for a MySQL user using the Nexcess Cloud SiteWorx Control Panel. With proper permissions, users can manage the database via remote database access.
This article will cover MySQL user account management for admins. MySQL is an open source database management software that helps users store, organize, and retrieve data. There are various options for granting specific users detailed privileges on tables and databases. This guide provides a brief overview of how easily you can manage MySQL user permissions for your / using the Nexcess Cloud SiteWorx Control Panel.
Attention: This article only applies to Nexcess clients using Magento and Flexible Cloud Plans. If you use our or Plans, do not hesitate to contact our 24/7 support team by email or through the Client Portal for assistance.
Log in to your Nexcess Client Portal and pick the product plan you have with Nexcess.
Are you looking forward to setting up MySQL user permissions for the database? You can accomplish this by using the Nexcess Cloud SiteWorx Control Panel available for our Magento/Flexible Cloud Plan users.
Navigate to the URL for the log in.
Either click the name of your Magento/Flexible Cloud Plan service, or select Plan Dashboard from the menu options:
From the dashboard, select the Menu > Control Panel option:
Click the Launch Control Panel button:
Your browser will redirect you to the Cloud Siteworx Control Panel home page.:
rom the SiteWorx main menu, click Hosting Features > MySQL > Databases:
On the Cloud SiteWorx Control Panel, navigate to the Hosting Features > MySQL > Databases > Existing Databases option. The Existing Databases section displays all the databases that you have on the current Magento or Flexible Cloud Plan:
Click on Manage Users to Add, Modify and Delete user privileges.
Attention: Privileges determine how users can interact with a database. This will, for instance, determine whether the user can add, modify and delete information:
To save the new user permissions, click on Add.
The Existing Permissions section displays current permissions/privileges a user has while connecting from a host. To update the current permissions, click on the Edit option.
Once you have made the desired changes, click on Save.
The following table defines the permissions available for application to a specific MySQL database user account.
Common Errors & Resolutions
If the user gets the following error, they are lacking corresponding permissions:
Take the following steps to remedy this error condition:
You enter an incorrect password or password for your database, so fixing these credentials can resolve this error.
You probably have an anonymous user '@'localhost' or '@'127.0.0.1'. The recommended solution is to authenticate the user when connecting from '%' host. You can do this in the MySQL user permissions page by adding '%' in ‘When Connecting From’ (see above).
If you feel lost or require a little help with your databases, our available 24/7/365 — and 366 days in leap years!
You should know how to grant permission in MySQL for a user assigned to a database. Depending on your needs, you may wish to explore different permissions settings for your database or learn about some higher-level MySQL configurations.
Build Better Sites and Stores With Fully Managed Hosting from Nexcess
Faster Speeds, Stronger Security, Inherent Scalability and Trusted Support.
Our range of hosting plans caters to any business scale. We do all the heavy lifting for you to focus on growing your business. In addition, we automatically update ore components and plugins to the latest version and ensure your hosting environment is properly optimized, secured, and updated.
Read more about the Fully Managed Cloud Environment by Nexcess and its benefits for your business.
A Cloud Hosting Solution That Lets You Do Business Your Way
We believe in the promise of cloud: scalability, security, performance, and ease of use. Together with our team, clients, and partners, we’ve built something better.
Choose From Multiple Applications
Whether you’re a small business or a high-traffic eCommerce store, our cloud hosting solutions are designed around your needs: auto scaling, PCI compliance, and comprehensive development tools provide you with maximum dynamic flexibility in a fully managed cloud environment.
We make applications easy with environment optimizations for:
Read more about the Fully Managed WordPress Hosting and its benefits for your business.
Build Better Websites with Fully Managed WordPress Hosting
It’s hosting optimized for WordPress. That means a faster, more secure and scalable website. Smart monitoring tools are built-in to help you keep it that way.
It’s why WordPress Users Trust Nexcess Hosting.
We also have a variety of Nexcess support articles about WordPress, including how to get your site going with a number of different configuration options. These resources include a great article on setting this up for Migrating to Nexcess with managed WordPress and managed WooCommerce hosting.
If you need any assistance with the above-mentioned, don't hesitate to reach out. For 24-hour assistance any day of the year, Nexcess customers can contact our support team by email or through your Client Portal.
Our award-winning customer care team is here for you.Contact Support