![]() On the Cloud SiteWorx Control Panel, navigate to the Hosting Features > MySQL > Databases > Existing Databases option. Step #5: Grant user permissions for a user on the MySQL database Navigate to the MySQL section and f rom the SiteWorx main menu, click Hosting Features > MySQL > Databases : Your browser will redirect you to the Cloud Siteworx Control Panel home page.: Step #3: Launch the SiteWorx Control Panel Navigate to the Control Panel page and click on Plans:Įither click the name of your Magento/Flexible Cloud Plan service, or select Plan Dashboard from the menu options:įrom the dashboard, select the Menu > Control Panel option: Step #2: Navigate to the Control Panel page Navigate to the URL for the Nexcess Client Portal log in. ![]() Procedures for Granting MySQL Database Permissions Step #1: Log in to your Nexcess Client Portal See How to create Nexcess Cloud accounts for more information.Īre 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. An existing Nexcess Cloud Account using a Magento Plano or a Flexible Cloud Plan.Click the Forgot Password? link on the login page i f you cannot locate them. Your Nexcess Client Portal login credentials.Log in to your Nexcess Client Portal and pick the product plan you have with Nexcess. If you use our Managed WordPressor Managed WooCommerce Plans, do not hesitate to contact our 24/7 support team by email or through the Client Portal for assistance. This guide provides a brief overview of how easily you can manage MySQL user permissions for your Magento / Flexible Cloud Plan using the Nexcess Cloud SiteWorx Control Panel.Īttention: This article only applies to Nexcess clients using Magento and Flexible Cloud Plans. There are various options for granting specific users detailed privileges on tables and databases. MySQL is an open source database management software that helps users store, organize, and retrieve data. This article will cover MySQL user account management for admins. ![]() With proper permissions, users can manage the database via remote database access. MySQL User Account Management: How to Manage MySQL Database User Permissions for a Magento/Flex Cloud PlanĪre you a Nexcess client using a Magento/ Flexible Cloud Plan ? This page contains information about how to grant, modify, and delete permissions for a MySQL user using the Nexcess Cloud SiteWorx Control Panel. GRANT SELECT (`User_ID`), SHOW VIEW ON Reports.`Users` to SELECT (`Campaign_ID`), SHOW VIEW ON Reports.`Users` to SELECT (`Created_Date`), SHOW VIEW ON Reports.`Users` to SELECT (`Company`), SHOW VIEW ON Reports.`Users` to SELECT (`City`), SHOW VIEW ON Reports.`Users` to SELECT (`State`), SHOW VIEW ON Reports.`Users` to SELECT (`Zip`), SHOW VIEW ON Reports.`Users` to SELECT (`Phone_Number`), SHOW VIEW ON Reports.`Users` to SELECT (`Credit_Card`), SHOW VIEW ON Reports.`Users` to only the statements for the columns you would like to grant access to and run those queries.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |